Skip to content

Instantly share code, notes, and snippets.

@swimtver

swimtver/delete

Created March 23, 2015 15:01
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save swimtver/b167212d22519c95e94e to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save swimtver/b167212d22519c95e94e to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. swimtver created this gist Mar 23, 2015.
    19 changes: 19 additions & 0 deletions delete
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,19 @@
    BEGIN transaction
    declare @number varchar(10)
    set @number = 'Л519187'

    DELETE c
    from dbo.Comments c
    join dbo.Workitems wi ON wi.Id=c.WorkItemId
    JOIN Claim.DamageClaims dc ON dc.Id = wi.DamageClaimId
    where Number = @number

    DELETE wi
    from dbo.Workitems wi
    JOIN Claim.DamageClaims c ON c.Id = wi.DamageClaimId
    where Number = @number

    DELETE
    FROM [Moas].[Claim].[DamageClaims]
    where Number = @number
    ROLLBACK