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

转载于:https://www.cnblogs.com/luking/archive/2006/08/04/467412.html