Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor syntax
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01340333
Message ID:
01340341
Views:
9
>Hi all!
>
>I need to create a cursor using the following syntax but I need to define my Select String base on the values that I receive. In other word I need to construct the Select statement first. Can I do that?
>
>Declare @SQLStatement = "Select * From AOP_Financial Journal"
>
>declare TempGregorio CURSOR for @SQLStatement.

Why?
That cursor will be useless if you didn't know beforehand which fields and how many of them you will SELECT?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform