代码改变世界

从数据库中删除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'