[MSSQL]创建工作流任务

 

--=======================创建新任务===========================
--作者:龚德辉
--用途：创建工作流的任务
--日期:2008-4-20
--=========================================================
ALTER Procedure [dbo].[CreateNewTask](
   @TaskCode        as nvarchar(11)=null
  ,@FlowCode        as nvarchar(10)=null
  ,@Confident       as nchar(1)=null
  ,@Priority        as nchar(1)=null
  ,@Important       as nchar(1)=null
  ,@CreateBy        as int=null
)
as
declare @Stat as nvarchar(1),@Progress nvarchar(1