USE Northwind DECLARE @SQLString NVARCHAR(500)/* Set column list. CHAR(13) is a carriage return, line feed.*/ SET @SQLString = N'SELECT FirstName, LastName, Title' + CHAR(13)/* Set FROM clause with carriage return, line feed. */ SET @SQLString = @SQLString + N'FROM Employees' + CHAR(13)/* Set WHERE clause. */ SET @SQLString = @SQLString + N'WHERE LastName LIKE ''D%'''EXEC sp_executesql @SQLString
DECLARE @SQLString NVARCHAR(500)/* Set column list. CHAR(13) is a carriage return, line feed.*/
SET @SQLString = N'SELECT FirstName, LastName, Title' + CHAR(13)/* Set FROM clause with carriage return, line feed. */
SET @SQLString = @SQLString + N'FROM Employees' + CHAR(13)/* Set WHERE clause. */
SET @SQLString = @SQLString + N'WHERE LastName LIKE ''D%'''EXEC sp_executesql @SQLString