exec sp_executesql N'SELECT EVENT_AUDIT_ID,AUDIT_TIME,AUDIT_TYPE,ACTIVITY_ID,ACTIVITY_NAME,PROCESS_ID,PROCESS_NAME,PROCESS_DEF_ID,PROCESS_DEF_NAME,PROCESS_DEF_VER,ACTIVITY_DEF_ID,ACTIVITY_SET_DEFINITION_ID,PACKAGE_ID FROM WF_EVENT_AUDIT WITH(NOLOCK) WHERE EVENT_AUDIT_ID=@P1', N'@P1 nvarchar(4000) ', N'wf8a8aa8521a8e92db011a904fd3201c6e';SELECT EVENT_AUDIT_ID,AUDIT_TIME,AUDIT_TYPE,ACTIVITY_ID,ACTIVITY_NAME,PROCESS_ID,PROCESS_NAME,PROCESS_DEF_ID,PROCESS_DEF_NAME,PROCESS_DEF_VER,ACTIVITY_DEF_ID,ACTIVITY_SET_DEFINITION_ID,PACKAGE_ID FROM WF_EVENT_AUDIT WITH(NOLOCK) WHERE EVENT_AUDIT_ID='wf8a8aa8521a8e92db011a904fd3201c6e';其中event_audit_id是主键。
LZ,把sp_executesql中@P1的定义成Event_Audit_id一样的类型跟长度。 exec sp_executesql N'SELECT EVENT_AUDIT_ID,AUDIT_TIME,AUDIT_TYPE,ACTIVITY_ID,ACTIVITY_NAME,PROCESS_ID,PROCESS_NAME,PROCESS_DEF_ID,PROCESS_DEF_NAME,PROCESS_DEF_VER,ACTIVITY_DEF_ID,ACTIVITY_SET_DEFINITION_ID,PACKAGE_ID FROM WF_EVENT_AUDIT WITH(NOLOCK) WHERE EVENT_AUDIT_ID=@P1', N'@P1 varchar(4000) ', N'wf8a8aa8521a8e92db011a904fd3201c6e';
exec sp_executesql N'SELECT EVENT_AUDIT_ID,AUDIT_TIME,AUDIT_TYPE,ACTIVITY_ID,ACTIVITY_NAME,PROCESS_ID,PROCESS_NAME,PROCESS_DEF_ID,PROCESS_DEF_NAME,PROCESS_DEF_VER,ACTIVITY_DEF_ID,ACTIVITY_SET_DEFINITION_ID,PACKAGE_ID FROM WF_EVENT_AUDIT WITH(NOLOCK) WHERE EVENT_AUDIT_ID=@P1', N'@P1 varchar(4000) ', N'wf8a8aa8521a8e92db011a904fd3201c6e';