Post reply

laucnh a slq request?

  • November 5, 2002 at 8:24 am

    #79041

    hi

    iwould like ton know how i can launch a sql request ihave sql server desktop engine 2000

    thanks

  • November 5, 2002 at 8:29 am

    #440332

    If you want to simply execute a query outside of an application, you can use Query Analyzer. To execute a query within an application ADO is probably the best method to access the data.

  • November 5, 2002 at 8:31 am

    #440333

    You also could use the "OSQL" utility if you want to launch a SQL command for the OS command prompt.

    Gregory Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

  • November 5, 2002 at 8:49 am

    #440335

    what is the command with osql to launche the file "1.sql"

    thanks

  • November 5, 2002 at 8:53 am

    #440337

    From the command prompt you would type something like:

    osql -S<servername> -U<username> -P<password> -i1.sql

    There are many switches associated with osql. You can issue: osql -? to get a list of all switchs. Hope this helps.

    Gregory Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply