22,209
社区成员
发帖
与我相关
我的任务
分享
DECLARE @p1 INT;
SET @p1 = 1073742525;
DECLARE @p2 INT;
SET @p2 = 180151329;
DECLARE @p7 INT;
SET @p7 = -1;
EXEC sp_cursorprepexec @p1 OUTPUT, @p2 OUTPUT, N'@P0 bigint,@P1 bit,@P2 bit',
N'select ctptemplat0_.ID as ID195_, ctptemplat0_.CATEGORY_ID as CATEGORY2_195_, ctptemplat0_.MODULE_TYPE as MODULE3_195_, ctptemplat0_.SUB_MODULE_TYPE as SUB4_195_, ctptemplat0_.TYPE as TYPE195_, ctptemplat0_.SUBJECT as SUBJECT195_, ctptemplat0_.IS_SYSTEM as IS7_195_, ctptemplat0_.CAN_SUPERVISE as CAN8_195_, ctptemplat0_.MEMBER_ID as MEMBER9_195_, ctptemplat0_.CREATE_DATE as CREATE10_195_, ctptemplat0_.MODIFY_MEMBER as MODIFY11_195_, ctptemplat0_.MODIFY_DATE as MODIFY12_195_, ctptemplat0_.SUMMARY as SUMMARY195_, ctptemplat0_.WORKFLOW_ID as WORKFLOW14_195_, ctptemplat0_.BODY as BODY195_, ctptemplat0_.BODY_TYPE as BODY16_195_, ctptemplat0_.STATE as STATE195_, ctptemplat0_.IS_DELETE as IS18_195_, ctptemplat0_.DESCRIPTION as DESCRIP19_195_, ctptemplat0_.ORG_ACCOUNT_ID as ORG20_195_, ctptemplat0_.IDENTIFIER as IDENTIFIER195_, ctptemplat0_.PROJECT_ID as PROJECT22_195_, ctptemplat0_.FORM_PARENTID as FORM23_195_, ctptemplat0_.TEMPLETE_NUMBER as TEMPLETE24_195_, ctptemplat0_.COL_SUBJECT as COL25_195_, ctptemplat0_.STANDARD_DURATION as STANDARD26_195_, ctptemplat0_.SORT as SORT195_, ctptemplat0_.CAN_TRACK_WORKFLOW as CAN28_195_ from CTP_TEMPLATE ctptemplat0_, CTP_TEMPLATE_CONFIG ctptemplat1_ where ctptemplat0_.ID=ctptemplat1_.TEMPLETE_ID and ctptemplat1_.MEMBER_ID=@P0 and ctptemplat1_.IS_DELETE=@P1 and ctptemplat0_.IS_DELETE=@P2 and ctptemplat0_.STATE=0 and (ctptemplat0_.IS_SYSTEM=1 and (ctptemplat0_.MODULE_TYPE in (-1 , 1 , 2 , 4 , 19 , 20 , 21 , 32)) or ctptemplat0_.IS_SYSTEM=0) order by ctptemplat1_.SORT, ctptemplat0_.CREATE_DATE ',
4112, 8193, @p7 OUTPUT, 3531102189960577122, 0, 0;
SELECT @p1 ,
@p2 ,
@p7