編輯器加載中...
delete DayTable whereexists(select Mobile from TrueEndTable with (nolock) whereconvert(varchar(6),procmsgtime,112) =convert(varchar(6),getdate(),112) and customID <>0and mobile = TrueTable.mobilegroupby Mobile havingsum(fee)<@sSumFee)--記錄DEl受影響行update DelDayLog set[Status]=1,OpRecord =@sOpRecord+convert(varchar(19),getdate(),120) +':刪除'+convert(varchar(4),@@ROWCOUNT) +'條數(shù)據(jù)成功'whereconvert(varchar(10),OpCurTime,120) =convert(varchar(10),getdate(),120) and[Status]=0
想請教各位大蝦convert(varchar(4),@@ROWCOUNT) @@ROWCOUNT=什么值的時候轉(zhuǎn)化成字符串 會等于 * 號?, 如果@@ROWCOUNT= '*' 那到底是刪除了多少行數(shù)據(jù)?
想記錄當(dāng)前刪除操作受影響的行數(shù)!問題:convert(varchar(4),@@ROWCOUNT)竟然=*號?
三國紛爭
2018-12-06 22:20:10