Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rdwilliamsjr
Starting Member
4 Posts |
 Posted - 2001-12-19 : 12:47:03
|
| USE pubs GO DECLARE @sql nvarchar(255) DECLARE @parm1 nvarchar(255) DECLARE @return1 nvarchar(255) SET @parm1 = N'@returnvalue int OUTPUT'SET @sql = N'SELECT @returnvalue = COUNT(*) FROM authors ' EXEC sp_executesql @sql, @parm1, @return1 OUTPUT PRINT CONVERT(nvarchar(255), @return1) |
|
|
|
|
|
Using sp_executesql instead of temporary tables