110,534
社区成员
发帖
与我相关
我的任务
分享
exec sp_executesql N'update bk_Circulate set LoanFlag=1, BkReturnDate=''2020-01-08 17:03:18''
where LoanFlag=0 and Barcode in (@Barcodes);UPDATE bk_Barcode SET CirculateFlag=0
WHERE Barcode in (@Barcodes)',N'@Barcodes nvarchar(8)',@Barcodes=N'''234690'''
--如果我换成如下,修改成功
update bk_Circulate set LoanFlag=1, BkReturnDate='2020-01-08 17:03:18'
where LoanFlag=0 and Barcode in ('234690')
UPDATE bk_Barcode SET CirculateFlag=0
WHERE Barcode in ('234690')
exec sp_executesql N'update bk_Circulate set LoanFlag=1, BkReturnDate=''2020-01-08 17:03:18''
where LoanFlag=0 and Barcode=@Barcodes;UPDATE bk_Barcode SET CirculateFlag=0
WHERE Barcode=@Barcodes',N'@Barcodes nvarchar(8)',@Barcodes=N'234690'