View Single Post
  #2 (permalink)  
Old April 29th, 2013, 04:36 PM
sidejack sidejack is offline
Authorized User
Points: 41, Level: 1
Points: 41, Level: 1 Points: 41, Level: 1 Points: 41, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2013
Location: Great Wet Northwest
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Talking Solved!

I can't take all the credit; I have a student smarter than I.

To run SQLCMD in the command line, one first needs to connect to the server, which in the example below is ORACLE-PC\SQLEXPRESS (case sensitive)

C:\SQLCMD -S ORACLE-PC\SQLEXPRESS <ENTER>
1>

At the 1> prompt, connect to the database (example uses Master) followed by GO

1>USE Master
2>GO
Changed database to 'Master'.
1>

Now one is ready to enter SELECT statements (use GO to execute)
Reply With Quote