Shulou(Shulou.com)05/31 Report--

This article shows you how to use exec in SqlServer to deal with variables in sql strings. The content is concise and easy to understand, which will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

In SqlServer, using exec to deal with sql strings contains variables, prompting that you must declare the scalar variable @ (resolved! )

The code is as follows:

Declare @ tssj nvarchar (100)-external variable

Declare @ Sql_Sql nvarchar (100)-store the 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 outputselect @ tssj

N'@tssj int output',@tssj output this sentence is the key, is the input variable parameters and outgoing variable parameters!

The above is how to use exec in SqlServer to deal with variables in sql strings. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.