How to concatenate strings containing variables in SQLSERVER

Editor to share with you how to concatenate SQLSERVER containing variable strings, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

1. Concatenate the string (the whole string is not divided):

First put single quotation marks before and after the string

Variables in a string are represented in a string as'+ @ para+'''

If there is a type conversion error during execution, the corresponding type conversion function is applied to type the variable (such as the cast () function).

Example 1:

Stored procedures that contain SQL concatenation strings:

Create Procedure Test @ TestID intAsDeclare @ s nvarchar Set @ s='Select * From dbo.Categories where CategoryID='''+cast (@ TestID as varchar) +''print @ sexec (@ s)

Execute:

Exec Test @ TestID=1

Execution result:

2. Concatenate strings (string segmentation) steps:

Enclose strings that do not contain variables in single quotes

Strings without variables are concatenated with variables with +

Variables are represented by'+ @ para+'''' (@ para is the variable name)

If a type conversion error occurs during the execution of the stored procedure, the corresponding type conversion function is used for conversion.

Example 2:

Stored procedures that contain SQL strings:

Create Procedure Test @ TestID intAsDeclare @ s nvarchar Set @ s='Select * From dbo.Categories where CategoryID='+''''+cast (@ TestID as varchar) +''print @ sexec (@ s)

Execute:

Exec Test @ TestID=1

Execution result:

The above is all the content of the article "how to concatenate SQLSERVER strings with variables". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!