从数据库中删除WWF的一个工作流实例

 

删除指定类型的工作流调用的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'