27,579
社区成员
发帖
与我相关
我的任务
分享
exec sp_executesql N'SELECT DISTINCT a.OBJ_ID,a.CLASS_ID FROM T_Part a WHERE a.Recycle_ID = 0 AND (a.IdentityNo=@P1) AND a.OBJ_ID <> 0 UNION SELECT DISTINCT a.OBJ_ID,a.CLASS_ID FROM P_Part a WHERE a.Recycle_ID = 0 AND (a.IdentityNo=@P2) AND a.OBJ_ID <> 0',N'@P1 nvarchar(128),@P2 nvarchar(128)',N'1231',N'1231'
exec sp_executesql N'SELECT DISTINCT a.OBJ_ID,a.CLASS_ID FROM T_Part a WHERE a.Recycle_ID = 0 AND (a.IdentityNo=@P1a.name=@P2) AND a.OBJ_ID <> 0 UNION SELECT DISTINCT a.OBJ_ID,a.CLASS_ID FROM P_Part a WHERE a.Recycle_ID = 0 AND (a.IdentityNo=@P3a.name=@P4) AND a.OBJ_ID <> 0',N'@P1 nvarchar(128),@P2 nvarchar(256),@P3 nvarchar(128),@P4 nvarchar(256)',N'1231',N'X',N'1231',N'X'
但是这一句就不行了,报错是@p3a处有错误,恩,我明白了,应该是两个条件连在一起了,那要怎么写啊,直接加空格不规范,加上AND没有查到结果。。。。。。