Sql sever 声明变量，赋值变量

云博小周宇2024年5月5日2023年8月23日1 Min Read

语句：

--声明变量
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