Sql sever 声明变量，赋值变量

语句：

--声明变量
DECLARE
    @idcard nvarchar (50) ,
    @rowid nvarchar (50) 
--给变量赋值
SELECT
    @idcard = '{0}',
    @rowid = '{1}' 
SELECT
    COUNT (1)
FROM
    employeeadjustapply WITH (NOLOCK)
WHERE
    idcard =@idcard
AND flagdeleted = 0
AND flagstatus = '有效'
AND flagaudit != - 1
AND AffairType != '证明申报'
AND flagdone = 0
AND rowid !=@rowid

 

转载于:https://www.cnblogs.com/gygtech/p/9895418.html