declare @cmd nvarchar(30) = 'SELECT * FROM Person.Address' EXEC (@cmd) go declare @cmd nvarchar(100) set @cmd = 'SELECT * FROM Person.Address where AddressID = @1 and PostalCode = @2' EXEC sp_executesql @cmd, N'@1 int, @2 nvarchar(15)', 1, '98011' go -- Using Dynamic SQL With Parameter Declare @cmd_param varchar = 1 Declare @cmd varchar(100) = N'Select * from employees where employeeid = ' + @cmd_param exec (@cmd) -- DDL - Create Table Declare @cmd varchar(100) Set @cmd = 'Create table TBL (col1 int)' exec (@cmd) select * from TBL; -- DROP Drop Table TBL