SET IDENTITY_INSERT [dbo].[store] ON;

Select * from store where store_id = 301;
if @@ROWCOUNT =0
BEGIN
INSERT INTO store ( Store_ID, Description, CompanyName, TradingAs, Address, ContactNo, VATRegNo, 
RegNo, StoreEmailAddress
) VALUES ('301', 'Cash Crusaders Westcliffe (Chatsworth)','Cash Crusaders Stores (Pty) Ltd','Cash Crusaders Westcliffe (Chatsworth)', 'Shop 14/ 51, Business Square Westcliff, Chatsworth, Durban','0310027870','4270290184','2020/027120/07','chatsworthbuyshopmgr@crusadersstores.co.za');
 END
ELSE
 BEGIN
UPDATE Store set Description = 'Cash Crusaders Westcliffe (Chatsworth)',CompanyName = 'Cash Crusaders Stores (Pty) Ltd', TradingAs = 'Cash Crusaders Westcliffe (Chatsworth)', Address='Shop 14/ 51, Business Square Westcliff, Chatsworth, Durban', ContactNo = '0310027870', VATRegNo = '4270290184',RegNo = '2020/027120/07', StoreEmailAddress = 'chatsworthbuyshopmgr@crusadersstores.co.za' where Store_ID = 301;
 END


 SET IDENTITY_INSERT [dbo].[store] off