DELETE FROM [dbo].[User] WHERE (([ID] = @Original_ID) AND ((@IsNull_Логин = 1 AND [Логин] IS NULL) OR ([Логин] = @Original_Логин)) AND ((@IsNull_Пороль = 1 AND [Пороль] IS NULL) OR ([Пороль] = @Original_Пороль)) AND ((@IsNull_Роль = 1 AND [Роль] IS NULL) OR ([Роль] = @Original_Роль))) INSERT INTO [dbo].[User] ([Логин], [Пороль], [Роль]) VALUES (@Логин, @Пороль, @Роль); SELECT ID, Логин, Пороль, Роль FROM [User] WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Логин, Пороль, Роль FROM dbo.[User] UPDATE [dbo].[User] SET [Логин] = @Логин, [Пороль] = @Пороль, [Роль] = @Роль WHERE (([ID] = @Original_ID) AND ((@IsNull_Логин = 1 AND [Логин] IS NULL) OR ([Логин] = @Original_Логин)) AND ((@IsNull_Пороль = 1 AND [Пороль] IS NULL) OR ([Пороль] = @Original_Пороль)) AND ((@IsNull_Роль = 1 AND [Роль] IS NULL) OR ([Роль] = @Original_Роль))); SELECT ID, Логин, Пороль, Роль FROM [User] WHERE (ID = @ID)