A small example in SQL Server that uses exec to handle variables contained in a _mssql

SQL Server, use exec to handle a variable in the SQL string, hint: The scalar variable must be declared @ (resolved!) ）

Copy Code code as follows:

declare @tssj nvarchar (100)--External variables
declare @Sql_Sql nvarchar (100)--Save SQL string variable

Set @Sql_Sql =n ' select @tssj =jpk from b where bzmc= ' China '

EXEC sp_executesql @Sql_Sql, N ' @tssj int output ', @tssj output
Select @tssj

N ' @tssj int output ', @tssj output
This sentence is the key, is passed the variable parameter and the outgoing variable parameter!