OSQL or ISQL

來源: 於 2003-11-25 10:21:00 [舊帖] [給我悄悄話] 本文已被閱讀：次

Start -> Run -> [cmd] then:
-E is trusted login.
You can write commnds into a bat script to run and to schemdule it.

Also, it is easier to manage if you use BCP in a batch.

H:>osql -E
1> use pubs
2> go
1> select top 1 * from authors
2> go
au_id au_lname .....



--文學城www.wenxuecity.com--