declare @Tablevar Table (
WeekEnding datetime null,
Salary money )

insert into @tablevar
values ( getdate(), 1234.45)

select * from @tablevar

-----Original Message-----
From: CBerko
[mailto:mssqldba-ezmlmshield-x15975874.[Email address protected]
Sent: Thursday, October 28, 2004 6:01 PM
To: LazyDBA Discussion
Subject: Table Variables



I know this is a really basic question but can someone please send me a
sample script defining a table variable with DECLARE and then using it.

Thanks

Craig Berko



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page