Tuesday, July 2, 2013

Create Dynamic Table


DECLARE @TBLREPORT TABLE (ID INT IDENTITY(1,1),FirstName NVARCHAR(MAX),LastName NVARCHAR(MAX),EmailAddress NVARCHAR(MAX))
---- TBLREPORT has no physical existence in Database
Insert Into @TBLREPORTSelect FirstName,LastName,EmailAddress from [AdventureWorks].[Person].[Contact] where Title='Mr.'
Select * from @TBLREPORT

No comments:

Post a Comment