以下是一个使用SQL Server的动态SQL用法的样例:
DECLARE @sql NVARCHAR(MAX); SET @sql = N'SELECT * FROM Employees WHERE Department = ' + @Department; EXEC sp_executesql @sql;
以下是一个使用SQL Server的动态SQL用法的样例:
DECLARE @sql NVARCHAR(MAX); SET @sql = N'SELECT * FROM Employees WHERE Department = ' + @Department; EXEC sp_executesql @sql;