First time user. How do I execute SQL like @ in Oracle

[Michael]

In order to execute sql in Oracle, I use @sample.sql.

In SQL server, how can I execute it?

[Jun]

Does your SQL DBA set up an account for you to access SQL server? Do you have a SQL Client or server installed on your PC? (If you do not, perhaps you should talk to your SQL DBA first) If you can start SQL Server Enterprise Manager, go to the "Tool" and Highlight "Query Analyzer" and choose your database to run the query. Then you can write or load your sql script. Click the Green Triangle to run your query.

Hope this helps!


------------
Michael at 3/26/01 3:42:51 PM


In order to execute sql in Oracle, I use @sample.sql.

In SQL server, how can I execute it?

[Michael]

Thanks for the reply.

However, SQL Server and Oracle must use a different approach to run

sql script. According to your reply, unless the script is saved as sotred

procedure, I should load script using File-Open-Open Query File. Is that

right?

[Jun]

There are a couple of ways to run your script. But Open your script in the Query Analyzer is one of the easiest way. Just try to write a very simple Query such as "SELECT * FROM TableName (choosse any table from NorthWind database)" and run it, you will get some feeling.

Jun


------------
Michael at 3/26/01 4:38:48 PM

Thanks for the reply.

However, SQL Server and Oracle must use a different approach to run

sql script. According to your reply, unless the script is saved as sotred

procedure, I should load script using File-Open-Open Query File. Is that

right?