declare @str Nvarchar(100),@Q varchar(100)
set @str='select '+@Q+'=empco from Employees'
exec sp_executesql @str,N'@Q varchar(100) output',@Q varchar(100) output
print @Q
set @str='select '+@Q+'=empco from Employees'
exec sp_executesql @str,N'@Q varchar(100) output',@Q varchar(100) output
print @Q
declare @str Nvarchar(100),@Q varchar(100)
set @str='select @Q=empco from Employees'
exec sp_executesql @str,N'@Q varchar(100) output',@Q varchar(100) output
print @Q
第 3 行: 'varchar' 附近有语法错误。
请问一下,这个东东是做什么的?sp_executesql
declare @str Nvarchar(100),@Q varchar(100)
set @str='select @Q=empco from Employees'
exec sp_executesql @str,N'@Q varchar(100) output',@Q output
print @Q
declare @re varchar(100) select @sql='select @q=empco from employess'
select @para='@q varchar(100) output'
exec sp_executesql @sql,@para,@re output
print @re