SET IDENTITY_INSERT [dbo].[store] ON;

Select * from store where store_id = 326;
if @@ROWCOUNT =0
BEGIN
INSERT INTO store ( Store_ID, Description, CompanyName, TradingAs, Address, ContactNo, VATRegNo, 
RegNo, StoreEmailAddress
) VALUES ('326', 'Cash Crusaders Tongaat','Cash Crusaders Stores (Pty) Ltd','Cash Crusaders Tongaat','Shop B6 oThongathi Mall, c/o Ganie street and 263 Gopalall Hurbans road, Tongaat, 4339','0877111599','TBA','TBA','TBA');
 END
ELSE
 BEGIN
UPDATE Store set Description = 'Cash Crusaders Tongaat',CompanyName = 'Cash Crusaders Stores (Pty) Ltd', TradingAs = 'Cash Crusaders Tongaat', Address='Shop B6 oThongathi Mall, c/o Ganie street and 263 Gopalall Hurbans road, Tongaat, 4339', ContactNo = '0877111599', VATRegNo = 'TBA',RegNo = 'TBA', StoreEmailAddress = 'TBA' where Store_ID = 326;
 END


 SET IDENTITY_INSERT [dbo].[store] off