IFEXISTS(SELECT*FROM SYSOBJECTS WHERE NAME ='ValueFromSql') DROPPROC ValueFromSql GO createproc ValueFromSql asbegin declare@valuevarchar(100) exec sp_executesql N'select @value=''From Sql''',N'@value varchar(100) out ',@value out print@value end
执行结果为; From Sql
如果想把sql语句当成变量传入,定义应该如下,注意@sql的类型应该是nvarchar
IFEXISTS(SELECT*FROM SYSOBJECTS WHERE NAME ='ValueFromSql') DROPPROC ValueFromSql GO createproc ValueFromSql asbegin declare@valuevarchar(100) declare@sqlnvarchar(4000) set@sql='select @value=''From Sql''' exec sp_executesql @sql,N'@value varchar(100) out ',@value out print@value end