Running SQL script 1

[aharrisreid]

Hi,

I have a .sql script to create SQL tables, but I am using MSDE instead of SQL-server. How can I run the script using T-SQL syntax?

Thanks,
Alan

 

[SQLBill]

Use the OSQL command flag -i.

For example, let's say your script is saved as:
C:\Programs\SQLScripts\MyScript.sql

You would run:

C:\> osql -E -i C:\Programs\SQLScripts\MyScript.sql

The -E means you are using a trusted connection.

Refer to the BOL and look up OSQL for more information.

-SQLBill

BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine

Posting advice: FAQ481-4875

 

[aharrisreid]

SQLBill, thanks for the reply.

>Refer to the BOL and look up OSQL for more information.

I am using MSDE, not SQL-Server, so BOL is not installed AFAIK. Do you know of any other resource (on the web, perhaps) worth reading?

Regards,
Alan

 

[cyberbiker]

SQLBill,

That little piece of info just opened up a whole new outlook for me in ref to MSDE.

Thanks

Terry (cyberbiker)

 

[ESquared]

You don't have to have SQL Server installed. Just download SQL Server 2000 Books Online by itself!

Here's the English version directly from Microsoft if you just want to download the installer: [URL unfurl="true"]http://download.microsoft.com/download...sqlbolsetup.msi[/url]