sql output
use message
declare @cmd as nvarchar(200)
declare @name as nvarchar(200)
declare @exchange as nvarchar(200)
set @cmd='select username from systemuser where useraccounts=''ABC'''
select @cmd as '@cmd'
exec sp_executesql @cmd,N'@exchange nvarchar(200) output',@exchange output
select @exchange as 'Condition'



[解决办法]

SQL code

declare @cmd  nvarchar(8000) declare @exchange  nvarchar(200) set @cmd= 'select @username=username from systemuser where useraccounts= ''ABC ''' exec sp_executesql @cmd,N '@username nvarchar(200) output ',@exchange output