Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 var table

Author  Topic 

getfar
Starting Member

15 Posts

Posted - 2005-09-21 : 08:56:24
is it possible to declare è table var?

thanks

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2005-09-21 : 09:01:24
DECLARE @vartab TABLE(Col1 INT,
Col2 INT)

INSERT INTO @vartab VALUES (1, 1)
INSERT INTO @vartab VALUES (1, 2)
INSERT INTO @vartab VALUES (1, 3)
INSERT INTO @vartab VALUES (2, 1)

SELECT * FROM @vartab

Duane.
Go to Top of Page
   

- Advertisement -