Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Macro substitute equivalent in SQLServer 6.5
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00232108
Message ID:
00232144
Views:
13
You can use the Execute command. Try this code in the Query Analyzer:

Declare @cString As Char(100)
Set @cString = "Use Northwind"
Execute(@cString)

In your case, it is very simple to qualify the database. For example, to fully reference the customers table in the Northwind database:

northwind.dbo.customers

The following code will work:

Declare @String As char(100)
Set @string = "Select * From northwind.dbo.customers"
Execute(@string)



HTH
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform