Home Forums SQL Server 2005 T-SQL (SS2K5) Delete certain records in table RE: Delete certain records in table

  • July 29, 2009 at 11:59 pm

    #1032180

    I prefer using DELETE

    FROM [TableName]

    WHERE RowID IN (

    <Subquery here>

    )

    I like this, because it's very clear which table you are deleting rows from.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA