Delete the non-duplicate row from actual Database Table in SQL SERVER 2008

I have one table variable “@Temp” and one database table “Master”.
Following data in both tables:

“@Temp”

ID
1
2

“Master”

ID
1
2
3

Now i have to delete row from Master table where ID is not matched from @temp table, i.e, ID number 3 will be deleted from Master Table.


Download delete.the.non.duplicate.row.from.actual.database.table.in.sql.server.2008.zip
Direct Link


Download


Download delete.the.non.duplicate.row.from.actual.database.table.in.sql.server.2008.zip
Mediafire


Download


Download delete.the.non.duplicate.row.from.actual.database.table.in.sql.server.2008.zip
Gboxes


Download

Both comments and pings are currently closed.

Comments are closed.