SET IDENTITY_INSERT [dbo].[store] ON;

Select * from store where store_id = 320;
if @@ROWCOUNT =0
BEGIN
INSERT INTO store ( Store_ID, Description, CompanyName, TradingAs, Address, ContactNo, VATRegNo, 
RegNo, StoreEmailAddress
) VALUES ('320', 'Cash Crusaders Clearview Square','Cash Crusaders Stores (Pty) Ltd','Cash Crusaders Clearview Square','Shop 17 Clearview Square, Rustenburg','0877111489','',' 2012/003211/07','');
 END
ELSE
 BEGIN
UPDATE Store set Description = 'Cash Crusaders Clearview Square',CompanyName = 'Cash Crusaders Stores (Pty) Ltd', TradingAs = 'Cash Crusaders Clearview Square', Address='Shop 17 Clearview Square, Rustenburg', ContactNo = '0877111489', VATRegNo = '',RegNo = ' 2012/003211/07', StoreEmailAddress = '' where Store_ID = 320;
 END


 SET IDENTITY_INSERT [dbo].[store] off