Skip to content

Instantly share code, notes, and snippets.

@xivSolutions

xivSolutions/gist:45d3403f6fcb69f053b7

Created May 26, 2014 19:56
Show Gist options
  • Save xivSolutions/45d3403f6fcb69f053b7 to your computer and use it in GitHub Desktop.
Save xivSolutions/45d3403f6fcb69f053b7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
-- In Postgres I can do THIS for a table with a composite PK:
DELETE FROM [Building] WHERE (PropertyId, BuildingId) IN ((1,6),(1,7),(1,8),(1,9),(1,10))
-- What is the SQL Server Equivelent? Or is there one? Am I stuck with some horrible nested subquery?
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment