DELETE FROM [dbo].[Country] WHERE (([id_country] = @Original_id_country) AND ([country] = @Original_country)) INSERT INTO [dbo].[Country] ([country]) VALUES (@country); SELECT id_country, country FROM Country WHERE (id_country = SCOPE_IDENTITY()) SELECT id_country, country FROM dbo.Country UPDATE [dbo].[Country] SET [country] = @country WHERE (([id_country] = @Original_id_country) AND ([country] = @Original_country)); SELECT id_country, country FROM Country WHERE (id_country = @id_country)