use pubs
DECLARE @CommandString NVARCHAR(255)
DECLARE @AuthorName NVARCHAR(255)
SELECT @CommandString = 'SELECT @AuthorName=au_fname + '' '' + au_lname ' +
' from Authors WHERE au_id = ''172-32-1176'' '
exec sp_executesql @CommandString
,N'@AuthorName NVARCHAR(255) out'
,@AuthorName outselect 结果=@AuthorName
DECLARE @CommandString NVARCHAR(255)
DECLARE @AuthorName NVARCHAR(255)
SELECT @CommandString = 'SELECT @AuthorName=au_fname + '' '' + au_lname ' +
' from Authors WHERE au_id = ''172-32-1176'' '
exec sp_executesql @CommandString
,N'@AuthorName NVARCHAR(255) out'
,@AuthorName outselect 结果=@AuthorName
---------
Johnson White(所影响的行数为 1 行)