Interview questions

SQL Server - What is SQLCMD?

Next>>         SQL Server tutorial  

SQL Server - What is SQLCMD? - Feb 27, 2010 at 11:50 AM by Shuchi Gauri

What is SQLCMD?

It’s a utility that allows entering T-SQL statements, system procedures and script files in command prompt. The utility uses OLEDB to execute T-SQL batches.

SQL Server - What is SQLCMD? - May 05, 2009 at 22:00 PM by Rajmeet Ghai

What is SQLCMD?

SQLCMD is a command line utility that is used to run queries from the command prompt. The queries and T-SQL commands are run against the default instance of SQL server. This, however, can be changed using –S for switching to another instance.

SQL Server - What is SQLCMD? - June 21, 2009 at 09:00 AM by Amit Satpute

The sqlcmd utility is basically for users who naive to the command-line utility.

It can be used to run ad hoc Transact-SQL statements and scripts.

The sqlcmd utility typically is used in these ways:

The Transact-SQL statements can be entered in SQLCMD the same way they are entered while working at the command prompt.

The sqlcmd job can be submitted by specifying a single Transact-SQL statement to execute or by pointing the utility to a script file that contains Transact-SQL statements to execute.


Also read

Define temporary and extended stored procedure.

Answer - Temporary Stored Procedure is stored in TempDB database. It is volatile and is deleted once connection gets terminated or server is restarted......

Define Primary and Unique key.

Answer - The column or columns of the table whose value uniquely identifies each row in the table is called primary key. You can define column as primary key using primary key constraint while you create table.....

What is index? Define its types.

Answer - Index can be thought as index of the book that is used for fast retrieval of information. Index uses one or more column index keys and pointers to the record to locate record.........

Write your comment - Share Knowledge and Experience


Latest placement tests
Latest links
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring