SET IDENTITY_INSERT [dbo].[store] ON;
Select * from store where store_id = 28;
if @@ROWCOUNT =0
BEGIN
INSERT INTO store ( Store_ID, Description, CompanyName, TradingAs, Address, ContactNo, VATRegNo, 
RegNo, StoreEmailAddress
) VALUES ('28', 'Cash Crusaders Vanderbijlpark','Cash Crusaders Vanderbijlpark','Cash Crusaders Stores (Pty) Ltd','Shop 1, Jorita Building, Corner of F W Beyers and D F Malan Street, Vanderbijlpark','NULL', '4270290184','2020/027120/07','Vanderbijlparkmgr@crusadersstores.co.za');
 END
ELSE
 BEGIN
UPDATE Store set Description = 'Cash Crusaders Vanderbijlpark',CompanyName = 'Cash Crusaders Vanderbijlpark', TradingAs = 'Cash Crusaders Stores (Pty) Ltd', Address='Shop 1, Jorita Building, Corner of F W Beyers and D F Malan Street, Vanderbijlpark', ContactNo = 'NULL', VATRegNo = '4270290184',RegNo = '2020/027120/07', StoreEmailAddress = 'Vanderbijlparkmgr@crusadersstores.co.za' where Store_ID = 28;
 END
 SET IDENTITY_INSERT [dbo].[store] off