从数据库中删除WWF的一个工作流实例
2006-08-04 09:47 温森特 阅读(1178) 评论(1) 编辑 收藏 举报删除指定类型的工作流调用的SQL语句:
select wi.WorkflowInstanceId, wi.WorkflowInstanceInternalId
from Type t
inner join Workflow w
on t.TypeId = w.WorkflowTypeId
inner join WorkflowInstance wi
on w.WorkflowTypeId = wi.WorkflowTypeId
where t.TypeFullName = --<type full name> i.e. 'Microsoft.WinOE.Test.TestCases.Hosting.Providers.Tracking.OrderStateMachine.OrderWorkflow'
and t.AssemblyFullName = --<assembly full name> i.e. 'Microsoft.WinOE.Test.TestCases.Hosting.Tracking, Version=3.0.0.0, Culture=neutral, PublicKeyToken=null'
您的支持,我的动力!