DECLARE @SQLSTR NVARCHAR(100),Declare @DinerCount intSET @SQLSTR = N'SELECT @X = COUNT(sPhoneNO) FROM TABLENAME'exec sp_executesql @SQLSTR, N'@X int output', @DinerCount output
调试欢乐多
declare @sql nvarchar(1000),@EmpCount int
set @sql=N'set @EmpCount=(Select Count(*) from Employee)'
exec sp_executesql @sql,N'EmpCount int OUTPUT',@EmpCount OUTPUT
select @EmpCount
declare @sql nvarchar(1000)
set @sql=N'set @EmpCount=(Select Count(*) from Employee)'
exec sp_executesql @sql,N'@EmpCount int OUTPUT',@DinerCount OUTPUT
select @DinerCount
Declare @DinerCount int
Select @DinerCount=Count(*) From Employee
中的N是起什么作用呢
exec('Select * FROM Employee ')
SELECT @DinerCount =@@ROWCOUNT这样就可以了