DECLARING Variables

Question

Post reply

DECLARING Variables

dB-226266

Ten Centuries

Points: 1298
More actions
April 19, 2005 at 3:29 am

#76287

In Oracle a variable can be declared this way:

aVariable TABLE1.COLUMN1%type;
so you don't need to know the type of the column in oracle, I think
it is dynamically looked up..

Is this possible in SQL Server if so Please teach me.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

No, this is not possible in SQL Server.

Maybe this will help: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=7956

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

dB-226266 Ten Centuries Points: 1298 More actions · Answer 2

I figured.

Well I just want some confirmation. There's this client who want's the oracle plsql to be converted to SQLServer T-SQL and I have already encountered so many bumps on the road. for instance writing to a file which is convenient in the code but not possible in SQLServer (but one can extend sp). Then there's the cursor with the parameters so the values change when the parameters change, then there's the global variables. etc etc...

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

See if this helps: http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0761.mspx

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

dB-226266 Ten Centuries Points: 1298 More actions · Answer 4

Thanks, the links did a great help... It gave me some tips. on the stored procedure part.