Purpose of KILL command

Next>>         SQL Server tutorial  

SQL Server - purpose of KILL command - Feb 27, 2010 at 11:50 AM by Shuchi Gauri

Explain the purpose of KILL command. Provide an example.

The KILL command is used to terminate a user process that is based on the session ID.

Syntax:

KILL{session ID} {WITH STATUSONLY}

SQL Server - purpose of KILL command - May 05, 2009 at 22:00 PM by Rajmeet Ghai

Explain the purpose of KILL command. Provide an example.

A KILL command in SQL is used to end or KILL a sql server process that is identified using a system process id. The process is killed based on the work load on the current session.

Syntax:
KILL 12;
KILL 12 WITH STATUS ONLY
All transaction associated with session id “12” are killed. STATUS ONLY if used, shows a progress report of the roll back due to an earlier KILL statement

SQL Server - purpose of KILL command - June 21, 2009 at 09:00 AM by Amit Satpute

The kill command terminates a user process that is based on the session ID or unit of work.

Next>>

Also read

Explain GO Command.

Answer - GO Command is used to signal the end of a batch.....

Define Truncate and Delete commands.

Truncate command is used to remove all rows of the column, the removed records are not recorded in the transaction log..............

SQL Server method to insert data

Brief about Insert Statement with an example.
Brief about Select….into statement with an example.
Brief about Bulk copy with an example.
Describe how bcp command prompt utility is used to import and export data.
Describe how bulk insert statement is used to import data..........

What are the commands available for Summarizing Data in SQL Server?

Answer - We have CUBE or ROLLUP operators to generate summary reports. Both are part of the GROUP BY....