Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > osql command reference?
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 9th March 07:14
stefan m. huber
External User
 
Posts: 1
Default osql command reference?


Hi!

I have been looking for a complete command reference to osql. A do***ent
that describes all possible SQL commands that you acn use. Unfortunately,
I seem too stupid :/
I haven't found:
* the complete desciption of BACKUP and RESTORE
* a way to show the table definitions.

TIA,
Stefan
  Reply With Quote


  sponsored links


2 9th March 07:14
narayana vyas kondreddi
External User
 
Posts: 1
Default osql command reference?


At command prompt, run the following command and it will show you all
switches available for OSQL.

OSQL /?

Also see the topic "osql utility" in SQL Server 2000 Books Online.

Similarly, SQL Server Books Online has complete do***entation on BACUP and
RESTORE commands.

sp_help will give you table definitions and you can generate table creation
scripts in Enterprise Manager.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm


Hi!

I have been looking for a complete command reference to osql. A do***ent
that describes all possible SQL commands that you acn use. Unfortunately,
I seem too stupid :/
I haven't found:
* the complete desciption of BACKUP and RESTORE
* a way to show the table definitions.

TIA,
Stefan
  Reply With Quote
3 9th March 07:14
stefan m. huber
External User
 
Posts: 1
Default osql command reference?


These, I know, thanks

Thanks, that helped me to find my way through. I found an online reference at
<http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/>.

Stefan
  Reply With Quote
4 9th March 07:14
hari prasad
External User
 
Posts: 1
Default osql command reference?


Hi,

Books online is the best option to learn all commands and usage.

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

* the complete desciption of BACKUP and RESTORE

See backup and Restore in books online

* a way to show the table definitions.

sp_help <table_name>

* OSQL

See OSQL in books online

--
Thanks
Hari
MCDBA
  Reply With Quote
5 9th March 07:14
narayana vyas kondreddi
External User
 
Posts: 1
Default osql command reference?


The online reference you found is for Sybase and is not valid for Microsoft
SQL Server. Follow Hari's link.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm


On Mon, 19 Jul 2004 11:09:11 +0100, Narayana Vyas Kondreddi
<answer_me@hotmail.com> wrote:

These, I know, thanks

Thanks, that helped me to find my way through. I found an online reference at
<http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/>.

Stefan
  Reply With Quote
6 9th March 07:15
stefan m. huber
External User
 
Posts: 1
Default osql command reference?


Thanks!

And while my other link isn't for MSDE, most of the things discussed there
work in MSDE as well

Stefan
  Reply With Quote
7 9th March 07:15
alan brewer [msft]
External User
 
Posts: 1
Default osql command reference?


osql is primarily a utility for running Transact-SQL statements on an
instance of SQL Server, including MSDE 2000. The primary reference for most
of the statements you can run using osql is the Transact-SQL Reference in
the SQL Server 2000 Books Online.

You can download the latest version of the SQL Server 2000 Books Online
from:

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

The latest version of the SQL Server 2000 Books Online is also published in
the MSDN Library at:

http://msdn.microsoft.com/library/?url=/library/en-us/startsql/portal_7ap1.asp?frame=true

These are topics about running osql that are in the copy of the Books Online
in MSDN:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_mta_01_5cmk.asp?frame=true
http://msdn.microsoft.com/library/?url=/library/en-us/coprompt/cp_osql_1wxl.asp?frame=true

This is the start of the Transact-SQL Reference in the MSDN copy of the
Books Online:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_tsqlcon_6lyk.asp?frame=true

--
Alan Brewer [MSFT]
Lead Programming Writer
SQL Server Do***entation Team

This posting is provided "AS IS" with no warranties, and confers no rights
  Reply With Quote
Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666