Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to return a cursor from sproc?
Message
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01163962
Message ID:
01163966
Views:
9
This message has been marked as the solution to the initial question of the thread.
>How do I return a cursor (temp table created in SQL Server stored procedure) back to VFP application?

Finish your SP with:
SELECT * from #TempTable
But why using temp table? Why not use table variable? When you use temp table you must care about uniqueness of its name.
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