DELETE FROM [dbo].[Performer] WHERE (([id_performer] = @Original_id_performer) AND ([performer] = @Original_performer)) INSERT INTO [dbo].[Performer] ([performer]) VALUES (@performer); SELECT id_performer, performer FROM Performer WHERE (id_performer = SCOPE_IDENTITY()) SELECT id_performer, performer FROM dbo.Performer UPDATE [dbo].[Performer] SET [performer] = @performer WHERE (([id_performer] = @Original_id_performer) AND ([performer] = @Original_performer)); SELECT id_performer, performer FROM Performer WHERE (id_performer = @id_performer)