wetmatter nonsense

let's get random 
Contributors
Tags


Filed under

table variables

 
August 13, 2008
 

Table Variables...SQL Server 2005

If you have ever created or have used #tempTables in SQL then using Table Variables will be a snap!

the norm for #tempTables are:

CREATE TABLE #tempTable
(
tempID INT NOT NULL,
firstName NVARCHAR(50),
createDate DATETIME DEFAULT (getdate() )
)

INSERT INTO #tempTable VALUES (100,'Samson',DEFAULT)
INSERT INTO #tempTable VALUES (200,'Stephen',DEFAULT)
INSERT INTO #tempTable VALUES (300,'David',DEFAULT)
INSERT INTO #tempTable VALUES (400,'Peter',DEFAULT)
INSERT INTO #tempTable VALUES (500,'Diana',DEFAULT)

SELECT * FROM #tempTable
DROP TABLE #tempTable

Media_http2bpblogspotcomkclclmdadaskmvz9btogiaaaaaaaaaegefn0kfaicgys320temptableresultesbmp_pkblaojkffbbtgi

the norm for Table Variables:

DECLARE @tableVariable TABLE
(
tableVarID INT NOT NULL,
firstName NVARCHAR(50),
createDate DATETIME DEFAULT (getdate() )
)

INSERT INTO @tableVariable VALUES (100,'Samson',DEFAULT)
INSERT INTO @tableVariable VALUES (200,'Stephen',DEFAULT)
INSERT INTO @tableVariable VALUES (300,'David',DEFAULT)
INSERT INTO @tableVariable VALUES (400,'Peter',DEFAULT)
INSERT INTO @tableVariable VALUES (500,'Diana',DEFAULT)

SELECT * FROM @tableVariable
DELETE @tableVariable

Media_http1bpblogspotcomkclclmdadaskmveqfidqiaaaaaaaaaeorw6hssarze0s320tablevariableresultesbmp_jafcvdsjzfcrhbf

Filed under  //   create table   database   rdbms   sql server 2005   table variables   temp tables  
Posted by Samson Loo 

Comments [0]