SET IDENTITY_INSERT [dbo].[store] ON;
Select * from store where store_id = 309;
if @@ROWCOUNT =0
BEGIN
INSERT INTO store ( Store_ID, Description, CompanyName, TradingAs, Address, ContactNo, VATRegNo, 
RegNo, StoreEmailAddress
) VALUES ('309', 'Cash Crusaders Navarre Pretoria CBD','Cash Crusaders Stores (PTY) LTD','Cash Crusaders Navarre Pretoria CBD','Shop 6, Navarre Building, Thabo Sehume Street, Pretoria CBD','TBA','4270290184','2020/027120/07','TBA');
 END
ELSE
 BEGIN
UPDATE Store set Description = 'Cash Crusaders Navarre Pretoria CBD',CompanyName = 'Cash Crusaders Stores (PTY) LTD', TradingAs = 'Cash Crusaders Navarre Pretoria CBD', Address='Shop 6, Navarre Building, Thabo Sehume Street, Pretoria CBD', ContactNo = 'TBA', VATRegNo = '4270290184',RegNo = '2020/027120/07', StoreEmailAddress = 'TBA' where Store_ID = 309;
 END
 SET IDENTITY_INSERT [dbo].[store] off