Advertisement
Guest User

Untitled

a guest
Jun 19th, 2020
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.65 KB | None | 0 0
  1. IF NOT EXISTS (select 1 from dbo.SSProductVatRate where VatSymbol = 'A') BEGIN INSERT INTO dbo.SSProductVatRAte VALUES(23, 'A') END;
  2. IF NOT EXISTS (select 1 from dbo.SSProductVatRate where VatSymbol = 'B') BEGIN INSERT INTO dbo.SSProductVatRAte VALUES(8, 'B') END;
  3. IF NOT EXISTS (select 1 from dbo.SSProductVatRate where VatSymbol = 'C') BEGIN INSERT INTO dbo.SSProductVatRAte VALUES(5, 'C') END;
  4. IF NOT EXISTS (select 1 from dbo.SSProductVatRate where VatSymbol = 'D') BEGIN INSERT INTO dbo.SSProductVatRAte VALUES(0, 'D') END;
  5. IF NOT EXISTS (select 1 from dbo.SSProductVatRate where VatSymbol = 'E') BEGIN INSERT INTO dbo.SSProductVatRAte VALUES(0, 'E') END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement