MS SQL Server exec and exec sp_executesql

When exec executes a SQL string, you cannot assign a value to the variable, and if you want to assign a value to the variable in SQL, use the EXEC sp_executesql

Example:

by sp_executesql The 2nd parameter to define which parameter outputs the output after the parameter is executed, the specific parameter of the data. Output add-inBEGIN   DECLARE @Sql NVARCHAR( $); DECLARE @name  VARCHAR(Ten); SET @Sql = 'SELECT @name = name from Test_dysql WHERE id=1'; PRINT @Sql; EXECsp_executesql@SqlN'@name VARCHAR () OUTPUT',@nameOUTPUT; PRINT @name; END GoSELECT @name =Name fromTest_dysqlWHEREId=1A

MS SQL Server exec and exec sp_executesql