SET IDENTITY_INSERT [dbo].[store] ON;
Select * from store where store_id = 316;
if @@ROWCOUNT =0
BEGIN
INSERT INTO store ( Store_ID, Description, CompanyName, TradingAs, Address, ContactNo, VATRegNo, 
RegNo, StoreEmailAddress
) VALUES ('316', 'Cash Crusaders The Boulders','MCPC 175 (Pty)Ltd','Cash Crusaders The Boulders','Shop 59A The Boulders, 1685 Old Pretoria Road, Halfway House, Midrand','TBA','4710279730','TBA','TBA');
 END
ELSE
 BEGIN
UPDATE Store set Description = 'Cash Crusaders The Boulders',CompanyName = 'MCPC 175 (Pty)Ltd', TradingAs = 'Cash Crusaders The Boulders', Address='Shop 59A The Boulders, 1685 Old Pretoria Road, Halfway House, Midrand', ContactNo = 'TBA', VATRegNo = '4710279730',RegNo = 'TBA', StoreEmailAddress = 'TBA' where Store_ID = 316;
 END
 SET IDENTITY_INSERT [dbo].[store] off