CODE SNIPPETS

All the Code Snippets and Samples you need

Microsoft SQL Server

How to use select statement in a delete statement using MSSQL

ByAdministrator

Feb 20, 2015 , , , , , , , , , , , , , , , , , , , , ,

To use select statement in a delete statement using MSSQL you can use the snippet below.

Sample MSSQL

DELETE TableOne
FROM   TableOne
       INNER JOIN TableTwo
               ON TableTwo.Id= TableOne.Id
                  AND ...
                       WHERE ...

By Administrator

Related Post

Microsoft SQL Server

How to get the current Database and Log Filesize using MSSQL

May 22, 2015 Administrator
Microsoft SQL Server

How to drop Primary Key of a Table using MSSQL

Apr 21, 2015 Administrator
Microsoft SQL Server

How to search stored procedures using MS-SQL

Apr 15, 2015 Administrator
4 thought on “How to use select statement in a delete statement using MSSQL”

Leave a Reply