Simple OSQL Tutorial

This is a great tutorial on using the text OSQL utility to work with MSDE or SQL Server databases.  It comes complete with instructions on logging in, listing all data bases, listing all tables within the selected db, and creating new users.

Some OSQL Examples from above:

osql -E -q "SELECT * FROM Northwind.dbo.Shippers"

osql -E -S ComputerName\InstanceName -i MyScript.sql -o MyOutput.rpt

osql -E -S ComputerName\InstanceName

tags: sqlserver, mssql, msde, sql, query

Related Scribbles:
  • SQL Server

  • ID: 795
    Date Updated:
    2011-07-25 01:32:49
    Date Created:
    2006-10-27 16:05:34


     >> Leonard Chan's Homepage  >> Scribble Web  >> Simple OSQL Tutorial is hosted by Perceptus Solutions Inc.