如果我在存储过程里拼接SQL语句,如下:
select @value = count(*) from UserInfo where UserID = @ipUserID;
然后通过判断@value来进行下面的操作,我该如何去做,该如何拼接
select @value = count(*) from UserInfo where UserID = @ipUserID;
然后通过判断@value来进行下面的操作,我该如何去做,该如何拼接
select @value = count(*) from UserInfo where UserID = @ipUserID;
if(@value = 0)
begin
end
else
begin
end
if(@value = 0)
begin
------你的处理
end
else
begin
------你的处理end
declare @sql = 'select'+ @value + '= count(*) from UserInfo where UserID = ' + @ipUserID;
exec (sql)
if @value is not null
begin end其实我是不会拼接这个SQL语句字符串
你是在过程内还是外?
内部用SET @value =(select count(*) from UserInfo where UserID = @ipUserID);
你想要的判断,,,外部
declare @i int,@s nvarchar(1000)
set @s=N'select @i =count(*) from NUM 'exec sp_executesql @s,N'@i int output',@i output--此处输出参数要加上N
select @i