SET IDENTITY_INSERT [dbo].[store] ON;

Select * from store where store_id = 318;
if @@ROWCOUNT =0
BEGIN
INSERT INTO store ( Store_ID, Description, CompanyName, TradingAs, Address, ContactNo, VATRegNo, 
RegNo, StoreEmailAddress
) VALUES ('318', 'Cash Crusaders Rustenburg Mall','JLM Handelaars (Pty)Ltd','Cash Crusaders Rustenburg Mall','Shop 113 Rustenburg Mall, Nelson Mandela Drive, Swartruggens road, Rustenburg','0834096968','4660260110','2024/698803/07','');
 END
ELSE
 BEGIN
UPDATE Store set Description = 'Cash Crusaders Rustenburg Mall',CompanyName = 'JLM Handelaars (Pty)Ltd', TradingAs = 'Cash Crusaders Rustenburg Mall', Address='Shop 113 Rustenburg Mall, Nelson Mandela Drive, Swartruggens road, Rustenburg', ContactNo = '0834096968', VATRegNo = '4660260110',RegNo = '2024/698803/07', StoreEmailAddress = '' where Store_ID = 318;
 END


 SET IDENTITY_INSERT [dbo].[store] off