stefan m. huber

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

narayana vyas kondreddi

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

stefan m. huber

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

hari prasad

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

narayana vyas kondreddi

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

stefan m. huber

Thanks!

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

Stefan

alan brewer [msft]

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