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.

http://www.codeproject.com/database/ConfigureMSDE.asp

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
    Author:
    leonard
    Date Updated:
    2011-07-25 01:32:49
    Date Created:
    2006-10-27 16:05:34

    Edit
    Comments?
     >> Leonard Chan's Homepage  >> Scribble Web  >> Simple OSQL Tutorial
    leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.