SET IDENTITY_INSERT [dbo].[store] ON;
Select * from store where store_id = 314;
if @@ROWCOUNT =0
BEGIN
INSERT INTO store ( Store_ID, Description, CompanyName, TradingAs, Address, ContactNo, VATRegNo, 
RegNo, StoreEmailAddress
) VALUES ('314', 'Cash Crusaders Tubatse Crossing','Cash Crusaders Tubatse Crossing','Cash Crusaders Stores (Pty) Ltd','Shop UG04A Tubatse Crossing, CNR R37 and R555, Burgersfort','015 291 4722', '4780288413','2018/300407/07','cschlebusch@broll.com');
 END
ELSE
 BEGIN
UPDATE Store set Description = 'Cash Crusaders Tubatse Crossing',CompanyName = 'Cash Crusaders Tubatse Crossing', TradingAs = 'Cash Crusaders Stores (Pty) Ltd', Address='Shop UG04A Tubatse Crossing, CNR R37 and R555, Burgersfort', ContactNo = '015 291 4722', VATRegNo = '4780288413',RegNo = '2018/300407/07', StoreEmailAddress = 'cschlebusch@broll.com' where Store_ID = 314;
 END
 SET IDENTITY_INSERT [dbo].[store] off