Friday, March 9, 2012

Declaration of record variable

Can someone say how to declare a record like variable in MSSQL-2000 Like:
mr_rec record of variables a int, b char(20), c datetime? I could not find any examples on BOL. I want to use this in a stored procedure create script.
Thanks, Vinniethere is no such thing as a "record" variable in mssql.

You can declare a table variable however, this might meet your need. A table variable is basically a temp table. See BOL for more info on table variables.

No comments:

Post a Comment