SET IDENTITY_INSERT [dbo].[store] ON;

Select * from store where store_id = 324;
if @@ROWCOUNT =0
BEGIN
INSERT INTO store ( Store_ID, Description, CompanyName, TradingAs, Address, ContactNo, VATRegNo, 
RegNo, StoreEmailAddress
) VALUES ('324', 'Cash Crusaders Norkem Corner','Cash Crusaders Stores (Pty) Ltd','Cash Crusaders Norkem Corner','Shop 21 & 22 Norkem Mall, 86 Quintus Van der Walt Drive, Norkem Park, 1618','0877111599','TBA','TBA','TBA');
 END
ELSE
 BEGIN
UPDATE Store set Description = 'Cash Crusaders Norkem Corner',CompanyName = 'Cash Crusaders Stores (Pty) Ltd', TradingAs = 'Cash Crusaders Norkem Corner', Address='Shop 21 & 22 Norkem Mall, 86 Quintus Van der Walt Drive, Norkem Park, 1618', ContactNo = '0877111599', VATRegNo = 'TBA',RegNo = 'TBA', StoreEmailAddress = 'TBA' where Store_ID = 324;
 END


 SET IDENTITY_INSERT [dbo].[store] off