SET IDENTITY_INSERT [dbo].[store] ON;

Select * from store where store_id = 325;
if @@ROWCOUNT =0
BEGIN
INSERT INTO store ( Store_ID, Description, CompanyName, TradingAs, Address, ContactNo, VATRegNo, 
RegNo, StoreEmailAddress
) VALUES ('325', 'Cash Crusaders Waterglen','RH van Zyl Retailers (PTY) Ltd','Cash Crusaders Waterglen','420 Mendelssohn St, Waterkloof, Pretoria, 0699','0877111599','4380253049','2024/791253/07','TBA');
 END
ELSE
 BEGIN
UPDATE Store set Description = 'Cash Crusaders Waterglen',CompanyName = 'RH van Zyl Retailers (PTY) Ltd', TradingAs = 'Cash Crusaders Waterglen', Address='420 Mendelssohn St, Waterkloof, Pretoria, 0699', ContactNo = '0877111599', VATRegNo = '4380253049',RegNo = '2024/791253/07', StoreEmailAddress = 'TBA' where Store_ID = 325;
 END


 SET IDENTITY_INSERT [dbo].[store] off