SQL Server Performance

DELETE statement

Discussion in 'T-SQL Performance Tuning for Developers' started by 1ANGO, Feb 5, 2008.

  1. 1ANGO New Member

    When you are deleting data in SQL Query Analyzer, and at the middle of deleting you cancelled it.... are there deleted data already? lmk thanks...
    1ANGO, Feb 5, 2008
    #2

  2. ndinakar Member

    Yep unless you enclosed it in a transaction.
    ndinakar, Feb 5, 2008
    #3

  3. mmarovic Active Member

    If you use cursor for deleting and no transactions then data are deleted. If you use single delete statement, then no, nothing is deleted. To find out the answer to such questions you can always test it yourself.
    mmarovic, Feb 6, 2008
    #4

Share This Page