Monday, March 12, 2012

oracle rowtype equivalent in T-Sql or SQL Server

Hi,
I am looking for an equivalent to %ROWTYPE of Oracle in SQL SERVER,
Please dont tell me that i need to use 100 or 200 variables if my cursor is having those many fields, as that will reduce the performance of the stored procedure where i need the solution.
VenkatHi,

Maybe, you could use a table variable that will contain only 1 row ?

No comments:

Post a Comment