Cannot create variable of type table

Hi all,
Just heard of table-type variables and wanted to try one out in a SP
(MS-SQL Server 7.0).
However, every time I try to declare such a variable as, (for instance)
:
declare @.mytbl table(pos_num smallint, seq_num smallint)
I get an error :
Error 156: Incorrect syntax near the word 'table' .
Any ideas as to what the problem here might be (I have full admin
rights on this particular database)?
TIA, RobertSQL Server 7.0 doesnt know about table variables:
http://developer.com/db/article.php/3414331
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"robertino" <rbanfield@.telair.com> schrieb im Newsbeitrag
news:1117443939.893947.77470@.g44g2000cwa.googlegroups.com...
> Hi all,
> Just heard of table-type variables and wanted to try one out in a SP
> (MS-SQL Server 7.0).
> However, every time I try to declare such a variable as, (for instance)
> :
> declare @.mytbl table(pos_num smallint, seq_num smallint)
> I get an error :
> Error 156: Incorrect syntax near the word 'table' .
> Any ideas as to what the problem here might be (I have full admin
> rights on this particular database)?
> TIA, Robert
>|||Table variables are not supported in7.0. They are available in SQL Server
2000.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"robertino" <rbanfield@.telair.com> wrote in message
news:1117443939.893947.77470@.g44g2000cwa.googlegroups.com...
Hi all,
Just heard of table-type variables and wanted to try one out in a SP
(MS-SQL Server 7.0).
However, every time I try to declare such a variable as, (for instance)
:
declare @.mytbl table(pos_num smallint, seq_num smallint)
I get an error :
Error 156: Incorrect syntax near the word 'table' .
Any ideas as to what the problem here might be (I have full admin
rights on this particular database)?
TIA, Robert|||Hmmm, just as I suspected - we have here SQL Server 2000 clients
running as frontends to a SQL Server 7 DB. Phooey! (Been on holiday, so
haven't been able to reply until now.)
Robert
Tom Moreau wrote:
> Table variables are not supported in7.0. They are available in SQL Server
> 2000.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "robertino" <rbanfield@.telair.com> wrote in message
> news:1117443939.893947.77470@.g44g2000cwa.googlegroups.com...
> Hi all,
> Just heard of table-type variables and wanted to try one out in a SP
> (MS-SQL Server 7.0).
> However, every time I try to declare such a variable as, (for instance)
> :
> declare @.mytbl table(pos_num smallint, seq_num smallint)
> I get an error :
> Error 156: Incorrect syntax near the word 'table' .
> Any ideas as to what the problem here might be (I have full admin
> rights on this particular database)?
> TIA, Robert