Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Question Unanswered: 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, Vinnie

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    there 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •