Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Syntax for OSQL cmd in QA

Status
Not open for further replies.
roswald

roswald

Programmer
Joined
Jul 6, 2002
Messages
152
Location
US
Can someone tell me how to get the syntax right for the following cmd in Query Analyzer...

set @cmd =
'OSQL -Uusername -Pmypwd -Q"select * from table"'

I have tried many combinations without any luck using single quotes so that it will work in a SP.
 
Sort by date Sort by votes
You need to use the extended procedure "xp_cmdshell". Refer to the BOL for the syntax directions.

-SQLBill

Posting advice: FAQ481-4875
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SashaBuilder3
  • Locked
  • Question Question
select a single row based on conditions in multiple rows
Replies
3
Views
1K
SashaBuilder3
SashaBuilder3
leifoet
  • Locked
  • Question Question
Error in Select query
Replies
14
Views
1K
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question Question
Eliminate pesky [ ] in SQL Management Studio
Replies
5
Views
893
SaltyTheFrog
SaltyTheFrog
Steve Yu
  • Locked
  • Question Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN
Replies
3
Views
889
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question Question
Group results into one row
2
Replies
37
Views
3K
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top