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
SQL Server - What is SQLCMD? - May 05, 2009 at 22:00 PM by
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
SQL Server - What is SQLCMD? - June 21, 2009 at 09:00 AM by
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.
Answer - Temporary Stored Procedure is stored in TempDB
database. It is volatile and is deleted once connection gets terminated or
server is restarted......
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.....
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.........