Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursors?
Message
 
 
To
06/09/2011 17:57:52
General information
Forum:
ASP.NET
Category:
Databases
Title:
Miscellaneous
Thread ID:
01522833
Message ID:
01522848
Views:
57
>>>>>With VFP I can select into a cursor (temporary table) and then manipulate that cursor to create the data I need for a report. Is there a similar technique when working with .NET and SQL Server? I have seen select into table but not anything similar to the VFP cursor.
>>>>>Thanks
>>>>
>>>>In SQL Server you can select into temporary table (table in the tempdb database) using into #TableName syntax. # before name indicates that it's a local temp table.
>>>
>>>
>>>Thanks Naomi. How do you release the temporary table?
>>
>>It is automatically closed once connection that created that table closes. Or you can also use
>>
>>IF object_id('tempdb..#TempName','U') IS NOT NULL drop table #TempName
>
>Thanks again. UT is the best! Can you help me with this one?
>http://forums.asp.net/t/1715921.aspx/1?Problem+with+profiles

This is not a simple problem. May be tonight I dig into my old files in regards to profile, as I remember we did have custom profile properties.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform