Hi everyOne...
I am new to sql Server and installed Ms sql 2005. i want to use command prompt for queries But whenever i use the sqlcmd command my computer gets restarted...
Why it is so????
can anyOne plz Help...
Hi everyOne...
I am new to sql Server and installed Ms sql 2005. i want to use command prompt for queries But whenever i use the sqlcmd command my computer gets restarted...
Why it is so????
can anyOne plz Help...
Use osql:
Start->Run->cmd
This will connect to the default instance on your local machine and return the instance information:
osql -E -q "SELECT @@VERSION"
http://msdn.microsoft.com/en-us/library/aa213088%28v=sql.80%29.aspx
There is a free tool "SQLS*Plus" which is an SQL*Plus for SQL Server. Works with SQL Server 2000/2005 and 2008
Very flexible with data formatting (set lines size, pagesize, etc), variables (&, &&), spool, etc - light years better than isql, osql or sqlcmd
I found it at http://www.memfix.com
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.