Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursors?
Message
 
 
À
06/09/2011 17:57:52
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Titre:
Divers
Thread ID:
01522833
Message ID:
01522848
Vues:
55
>>>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform