DELETE FROM [dbo].[Genre] WHERE (([id_genre] = @Original_id_genre) AND ([genre] = @Original_genre)) INSERT INTO [dbo].[Genre] ([genre]) VALUES (@genre); SELECT id_genre, genre FROM Genre WHERE (id_genre = SCOPE_IDENTITY()) SELECT id_genre, genre FROM dbo.Genre UPDATE [dbo].[Genre] SET [genre] = @genre WHERE (([id_genre] = @Original_id_genre) AND ([genre] = @Original_genre)); SELECT id_genre, genre FROM Genre WHERE (id_genre = @id_genre)