DELETE FROM [dbo].[City] WHERE (([idCity] = @Original_idCity) AND ((@IsNull_City = 1 AND [City] IS NULL) OR ([City] = @Original_City))) INSERT INTO [dbo].[City] ([City]) VALUES (@City); SELECT idCity, City FROM City WHERE (idCity = SCOPE_IDENTITY()) SELECT idCity, City FROM dbo.City UPDATE [dbo].[City] SET [City] = @City WHERE (([idCity] = @Original_idCity) AND ((@IsNull_City = 1 AND [City] IS NULL) OR ([City] = @Original_City))); SELECT idCity, City FROM City WHERE (idCity = @idCity) DELETE FROM [dbo].[IndexPartner] WHERE (([idIndex] = @Original_idIndex) AND ((@IsNull_CodePartner = 1 AND [CodePartner] IS NULL) OR ([CodePartner] = @Original_CodePartner))) INSERT INTO [dbo].[IndexPartner] ([CodePartner]) VALUES (@CodePartner); SELECT idIndex, CodePartner FROM IndexPartner WHERE (idIndex = SCOPE_IDENTITY()) SELECT idIndex, CodePartner FROM dbo.IndexPartner UPDATE [dbo].[IndexPartner] SET [CodePartner] = @CodePartner WHERE (([idIndex] = @Original_idIndex) AND ((@IsNull_CodePartner = 1 AND [CodePartner] IS NULL) OR ([CodePartner] = @Original_CodePartner))); SELECT idIndex, CodePartner FROM IndexPartner WHERE (idIndex = @idIndex) DELETE FROM [dbo].[Manager] WHERE (([idManager] = @Original_idManager) AND ((@IsNull_Surname = 1 AND [Surname] IS NULL) OR ([Surname] = @Original_Surname)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) AND ((@IsNull_Photo = 1 AND [Photo] IS NULL) OR ([Photo] = @Original_Photo))) INSERT INTO [dbo].[Manager] ([Surname], [Name], [Patronymic], [Login], [Password], [Photo]) VALUES (@Surname, @Name, @Patronymic, @Login, @Password, @Photo); SELECT idManager, Surname, Name, Patronymic, Login, Password, Photo FROM Manager WHERE (idManager = SCOPE_IDENTITY()) SELECT idManager, Surname, Name, Patronymic, Login, Password, Photo FROM dbo.Manager UPDATE [dbo].[Manager] SET [Surname] = @Surname, [Name] = @Name, [Patronymic] = @Patronymic, [Login] = @Login, [Password] = @Password, [Photo] = @Photo WHERE (([idManager] = @Original_idManager) AND ((@IsNull_Surname = 1 AND [Surname] IS NULL) OR ([Surname] = @Original_Surname)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) AND ((@IsNull_Photo = 1 AND [Photo] IS NULL) OR ([Photo] = @Original_Photo))); SELECT idManager, Surname, Name, Patronymic, Login, Password, Photo FROM Manager WHERE (idManager = @idManager) DELETE FROM [dbo].[Partner] WHERE (([idPartner] = @Original_idPartner) AND ((@IsNull_Surname = 1 AND [Surname] IS NULL) OR ([Surname] = @Original_Surname)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_idIndex = 1 AND [idIndex] IS NULL) OR ([idIndex] = @Original_idIndex)) AND ((@IsNull_idCity = 1 AND [idCity] IS NULL) OR ([idCity] = @Original_idCity)) AND ((@IsNull_idStreet = 1 AND [idStreet] IS NULL) OR ([idStreet] = @Original_idStreet)) AND ((@IsNull_House = 1 AND [House] IS NULL) OR ([House] = @Original_House)) AND ((@IsNull_INN = 1 AND [INN] IS NULL) OR ([INN] = @Original_INN)) AND ((@IsNull_Rating = 1 AND [Rating] IS NULL) OR ([Rating] = @Original_Rating)) AND ((@IsNull_idRegion = 1 AND [idRegion] IS NULL) OR ([idRegion] = @Original_idRegion)) AND ((@IsNull_idTypePartner = 1 AND [idTypePartner] IS NULL) OR ([idTypePartner] = @Original_idTypePartner)) AND ((@IsNull_NamePartner = 1 AND [NamePartner] IS NULL) OR ([NamePartner] = @Original_NamePartner))) INSERT INTO [dbo].[Partner] ([Surname], [Name], [Patronymic], [Email], [Phone], [idIndex], [idCity], [idStreet], [House], [INN], [Rating], [idRegion], [idTypePartner], [NamePartner]) VALUES (@Surname, @Name, @Patronymic, @Email, @Phone, @idIndex, @idCity, @idStreet, @House, @INN, @Rating, @idRegion, @idTypePartner, @NamePartner); SELECT idPartner, Surname, Name, Patronymic, Email, Phone, idIndex, idCity, idStreet, House, INN, Rating, idRegion, idTypePartner, NamePartner FROM Partner WHERE (idPartner = SCOPE_IDENTITY()) SELECT idPartner, Surname, Name, Patronymic, Email, Phone, idIndex, idCity, idStreet, House, INN, Rating, idRegion, idTypePartner, NamePartner FROM dbo.Partner UPDATE [dbo].[Partner] SET [Surname] = @Surname, [Name] = @Name, [Patronymic] = @Patronymic, [Email] = @Email, [Phone] = @Phone, [idIndex] = @idIndex, [idCity] = @idCity, [idStreet] = @idStreet, [House] = @House, [INN] = @INN, [Rating] = @Rating, [idRegion] = @idRegion, [idTypePartner] = @idTypePartner, [NamePartner] = @NamePartner WHERE (([idPartner] = @Original_idPartner) AND ((@IsNull_Surname = 1 AND [Surname] IS NULL) OR ([Surname] = @Original_Surname)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_idIndex = 1 AND [idIndex] IS NULL) OR ([idIndex] = @Original_idIndex)) AND ((@IsNull_idCity = 1 AND [idCity] IS NULL) OR ([idCity] = @Original_idCity)) AND ((@IsNull_idStreet = 1 AND [idStreet] IS NULL) OR ([idStreet] = @Original_idStreet)) AND ((@IsNull_House = 1 AND [House] IS NULL) OR ([House] = @Original_House)) AND ((@IsNull_INN = 1 AND [INN] IS NULL) OR ([INN] = @Original_INN)) AND ((@IsNull_Rating = 1 AND [Rating] IS NULL) OR ([Rating] = @Original_Rating)) AND ((@IsNull_idRegion = 1 AND [idRegion] IS NULL) OR ([idRegion] = @Original_idRegion)) AND ((@IsNull_idTypePartner = 1 AND [idTypePartner] IS NULL) OR ([idTypePartner] = @Original_idTypePartner)) AND ((@IsNull_NamePartner = 1 AND [NamePartner] IS NULL) OR ([NamePartner] = @Original_NamePartner))); SELECT idPartner, Surname, Name, Patronymic, Email, Phone, idIndex, idCity, idStreet, House, INN, Rating, idRegion, idTypePartner, NamePartner FROM Partner WHERE (idPartner = @idPartner) DELETE FROM [dbo].[ProductPartner] WHERE (([idPartnerProduct] = @Original_idPartnerProduct) AND ((@IsNull_idProduct = 1 AND [idProduct] IS NULL) OR ([idProduct] = @Original_idProduct)) AND ((@IsNull_idPartner = 1 AND [idPartner] IS NULL) OR ([idPartner] = @Original_idPartner)) AND ((@IsNull_CountProduct = 1 AND [CountProduct] IS NULL) OR ([CountProduct] = @Original_CountProduct)) AND ((@IsNull_DateSale = 1 AND [DateSale] IS NULL) OR ([DateSale] = @Original_DateSale))) INSERT INTO [dbo].[ProductPartner] ([idProduct], [idPartner], [CountProduct], [DateSale]) VALUES (@idProduct, @idPartner, @CountProduct, @DateSale); SELECT idPartnerProduct, idProduct, idPartner, CountProduct, DateSale FROM ProductPartner WHERE (idPartnerProduct = SCOPE_IDENTITY()) SELECT idPartnerProduct, idProduct, idPartner, CountProduct, DateSale FROM dbo.ProductPartner UPDATE [dbo].[ProductPartner] SET [idProduct] = @idProduct, [idPartner] = @idPartner, [CountProduct] = @CountProduct, [DateSale] = @DateSale WHERE (([idPartnerProduct] = @Original_idPartnerProduct) AND ((@IsNull_idProduct = 1 AND [idProduct] IS NULL) OR ([idProduct] = @Original_idProduct)) AND ((@IsNull_idPartner = 1 AND [idPartner] IS NULL) OR ([idPartner] = @Original_idPartner)) AND ((@IsNull_CountProduct = 1 AND [CountProduct] IS NULL) OR ([CountProduct] = @Original_CountProduct)) AND ((@IsNull_DateSale = 1 AND [DateSale] IS NULL) OR ([DateSale] = @Original_DateSale))); SELECT idPartnerProduct, idProduct, idPartner, CountProduct, DateSale FROM ProductPartner WHERE (idPartnerProduct = @idPartnerProduct) DELETE FROM [dbo].[Products] WHERE (([idProduct] = @Original_idProduct) AND ((@IsNull_idTypeProduct = 1 AND [idTypeProduct] IS NULL) OR ([idTypeProduct] = @Original_idTypeProduct)) AND ((@IsNull_Article = 1 AND [Article] IS NULL) OR ([Article] = @Original_Article)) AND ((@IsNull_MinCost = 1 AND [MinCost] IS NULL) OR ([MinCost] = @Original_MinCost))) INSERT INTO [dbo].[Products] ([idTypeProduct], [NameProduct], [Article], [MinCost]) VALUES (@idTypeProduct, @NameProduct, @Article, @MinCost); SELECT idProduct, idTypeProduct, NameProduct, Article, MinCost FROM Products WHERE (idProduct = SCOPE_IDENTITY()) SELECT idProduct, idTypeProduct, NameProduct, Article, MinCost FROM dbo.Products UPDATE [dbo].[Products] SET [idTypeProduct] = @idTypeProduct, [NameProduct] = @NameProduct, [Article] = @Article, [MinCost] = @MinCost WHERE (([idProduct] = @Original_idProduct) AND ((@IsNull_idTypeProduct = 1 AND [idTypeProduct] IS NULL) OR ([idTypeProduct] = @Original_idTypeProduct)) AND ((@IsNull_Article = 1 AND [Article] IS NULL) OR ([Article] = @Original_Article)) AND ((@IsNull_MinCost = 1 AND [MinCost] IS NULL) OR ([MinCost] = @Original_MinCost))); SELECT idProduct, idTypeProduct, NameProduct, Article, MinCost FROM Products WHERE (idProduct = @idProduct) DELETE FROM [dbo].[Region] WHERE (([idRegion] = @Original_idRegion) AND ((@IsNull_Region = 1 AND [Region] IS NULL) OR ([Region] = @Original_Region))) INSERT INTO [dbo].[Region] ([Region]) VALUES (@Region); SELECT idRegion, Region FROM Region WHERE (idRegion = SCOPE_IDENTITY()) SELECT idRegion, Region FROM dbo.Region UPDATE [dbo].[Region] SET [Region] = @Region WHERE (([idRegion] = @Original_idRegion) AND ((@IsNull_Region = 1 AND [Region] IS NULL) OR ([Region] = @Original_Region))); SELECT idRegion, Region FROM Region WHERE (idRegion = @idRegion) DELETE FROM [dbo].[Street] WHERE (([idStreet] = @Original_idStreet) AND ((@IsNull_Street = 1 AND [Street] IS NULL) OR ([Street] = @Original_Street))) INSERT INTO [dbo].[Street] ([Street]) VALUES (@Street); SELECT idStreet, Street FROM Street WHERE (idStreet = SCOPE_IDENTITY()) SELECT idStreet, Street FROM dbo.Street UPDATE [dbo].[Street] SET [Street] = @Street WHERE (([idStreet] = @Original_idStreet) AND ((@IsNull_Street = 1 AND [Street] IS NULL) OR ([Street] = @Original_Street))); SELECT idStreet, Street FROM Street WHERE (idStreet = @idStreet) DELETE FROM [dbo].[TypeMaterial] WHERE (([idTypeMaterial] = @Original_idTypeMaterial) AND ((@IsNull_TypeMaterial = 1 AND [TypeMaterial] IS NULL) OR ([TypeMaterial] = @Original_TypeMaterial)) AND ((@IsNull_PercentDefect = 1 AND [PercentDefect] IS NULL) OR ([PercentDefect] = @Original_PercentDefect))) INSERT INTO [dbo].[TypeMaterial] ([TypeMaterial], [PercentDefect]) VALUES (@TypeMaterial, @PercentDefect); SELECT idTypeMaterial, TypeMaterial, PercentDefect FROM TypeMaterial WHERE (idTypeMaterial = SCOPE_IDENTITY()) SELECT idTypeMaterial, TypeMaterial, PercentDefect FROM dbo.TypeMaterial UPDATE [dbo].[TypeMaterial] SET [TypeMaterial] = @TypeMaterial, [PercentDefect] = @PercentDefect WHERE (([idTypeMaterial] = @Original_idTypeMaterial) AND ((@IsNull_TypeMaterial = 1 AND [TypeMaterial] IS NULL) OR ([TypeMaterial] = @Original_TypeMaterial)) AND ((@IsNull_PercentDefect = 1 AND [PercentDefect] IS NULL) OR ([PercentDefect] = @Original_PercentDefect))); SELECT idTypeMaterial, TypeMaterial, PercentDefect FROM TypeMaterial WHERE (idTypeMaterial = @idTypeMaterial) DELETE FROM [dbo].[TypePartner] WHERE (([idTypePartner] = @Original_idTypePartner) AND ((@IsNull_Type = 1 AND [Type] IS NULL) OR ([Type] = @Original_Type))) INSERT INTO [dbo].[TypePartner] ([Type]) VALUES (@Type); SELECT idTypePartner, Type FROM TypePartner WHERE (idTypePartner = SCOPE_IDENTITY()) SELECT idTypePartner, Type FROM dbo.TypePartner UPDATE [dbo].[TypePartner] SET [Type] = @Type WHERE (([idTypePartner] = @Original_idTypePartner) AND ((@IsNull_Type = 1 AND [Type] IS NULL) OR ([Type] = @Original_Type))); SELECT idTypePartner, Type FROM TypePartner WHERE (idTypePartner = @idTypePartner) DELETE FROM [dbo].[TypeProduct] WHERE (([idTypeProduct] = @Original_idTypeProduct) AND ((@IsNull_TypeProduct = 1 AND [TypeProduct] IS NULL) OR ([TypeProduct] = @Original_TypeProduct)) AND ((@IsNull_Coefficient = 1 AND [Coefficient] IS NULL) OR ([Coefficient] = @Original_Coefficient))) INSERT INTO [dbo].[TypeProduct] ([TypeProduct], [Coefficient]) VALUES (@TypeProduct, @Coefficient); SELECT idTypeProduct, TypeProduct, Coefficient FROM TypeProduct WHERE (idTypeProduct = SCOPE_IDENTITY()) SELECT idTypeProduct, TypeProduct, Coefficient FROM dbo.TypeProduct UPDATE [dbo].[TypeProduct] SET [TypeProduct] = @TypeProduct, [Coefficient] = @Coefficient WHERE (([idTypeProduct] = @Original_idTypeProduct) AND ((@IsNull_TypeProduct = 1 AND [TypeProduct] IS NULL) OR ([TypeProduct] = @Original_TypeProduct)) AND ((@IsNull_Coefficient = 1 AND [Coefficient] IS NULL) OR ([Coefficient] = @Original_Coefficient))); SELECT idTypeProduct, TypeProduct, Coefficient FROM TypeProduct WHERE (idTypeProduct = @idTypeProduct) select 'Все типы' union all select type from TypePartner SELECT ProductPartner.idPartner, Products.NameProduct, ProductPartner.CountProduct, ProductPartner.DateSale FROM ProductPartner INNER JOIN Products ON ProductPartner.idProduct = Products.idProduct