Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Verify a TempTable using VFP on SQLServer2000
Message
 
 
To
25/02/2008 10:55:12
Bruno Maddalozzo
Informatica Aziendale
Arsie, Italy
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01296055
Message ID:
01296095
Views:
12
You're welcome.

>Yes, this is the way I adopted:
>
>
>SQLEXEC(lnActiveConnection,"SELECT object_id('tempdb..#TempQuery')","LocalCursor")
>
>If Isnull(LocalCursor.Exp)
>  SQLEXEC(lnActiveConnection,"create table #TempQuery ID char(36) PRIMARY KEY)")
>Endif
>
>
>
>Thank you very much Sergey and Naomi.
>Bruno
>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform