以前有一个存储过程,调试执行全没问题,是别人帮我写的,说真的我看不懂,但没有问题。现在我加了一个变量,自己试着修改这个存储过程,发现有问题。
我想请问:当把下面的 WantToOperater="test" 改成 WantToOperater=@WantToOperater1 时为什么总是提示 :必须声明变量 '@WantToOperater1' ???我把代码发上来先,请大哥们看看呢?麻烦了CREATE PROCEDURE [total_systemdata_dataname2]
(
@dataname char(32),
@WantToOperater1 char(30),
@Count int output
)
AS declare @TheStrWhere nvarchar (300)
set @TheStrWhere=' SELECT @Count = COUNT (ID) From ' + quotename(@dataname) + ' where LoadedUserId=''new'' and WantToOperater= "test" and WantToChange="1" 'exec sp_executesql @TheStrWhere,N'@Count int out',@Count out
GO
我想请问:当把下面的 WantToOperater="test" 改成 WantToOperater=@WantToOperater1 时为什么总是提示 :必须声明变量 '@WantToOperater1' ???我把代码发上来先,请大哥们看看呢?麻烦了CREATE PROCEDURE [total_systemdata_dataname2]
(
@dataname char(32),
@WantToOperater1 char(30),
@Count int output
)
AS declare @TheStrWhere nvarchar (300)
set @TheStrWhere=' SELECT @Count = COUNT (ID) From ' + quotename(@dataname) + ' where LoadedUserId=''new'' and WantToOperater= "test" and WantToChange="1" 'exec sp_executesql @TheStrWhere,N'@Count int out',@Count out
GO
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货