SHOW:
|
|
- or go back to the newest paste.
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; |