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
 SQL Server Development (2000)
 syntax error in using table variable sql2k

Author  Topic 

nimesh69
Starting Member

30 Posts

Posted - 2001-09-01 : 02:52:02
Hi,

I read about using table datatype instead of using temp tables. When I try following st'ment it gives me syntax error. I dug thru BOL/KB but now help.
Does anyone know what am I doing wrong?

DECLARE @MyTable TABLE ( au_id char(11), au_lname varchar(40) )

Any help would be greatly appreciated.
- Nimesh
   

- Advertisement -