DELETE FROM [dbo].[bronirovenie] WHERE (([nomer_kvitancii] = @Original_nomer_kvitancii) AND ((@IsNull_date_broni = 1 AND [date_broni] IS NULL) OR ([date_broni] = @Original_date_broni)) AND ((@IsNull_date_zaezda = 1 AND [date_zaezda] IS NULL) OR ([date_zaezda] = @Original_date_zaezda)) AND ((@IsNull_nomer_mesta = 1 AND [nomer_mesta] IS NULL) OR ([nomer_mesta] = @Original_nomer_mesta)) AND ((@IsNull_kod_clients = 1 AND [kod_clients] IS NULL) OR ([kod_clients] = @Original_kod_clients)) AND ((@IsNull_chislo_days = 1 AND [chislo_days] IS NULL) OR ([chislo_days] = @Original_chislo_days)) AND ((@IsNull_date_oplati = 1 AND [date_oplati] IS NULL) OR ([date_oplati] = @Original_date_oplati)) AND ((@IsNull_sale_oplata = 1 AND [sale_oplata] IS NULL) OR ([sale_oplata] = @Original_sale_oplata)) AND ((@IsNull_sale_season = 1 AND [sale_season] IS NULL) OR ([sale_season] = @Original_sale_season))) INSERT INTO [dbo].[bronirovenie] ([nomer_kvitancii], [date_broni], [date_zaezda], [nomer_mesta], [kod_clients], [chislo_days], [date_oplati], [sale_oplata], [sale_season]) VALUES (@nomer_kvitancii, @date_broni, @date_zaezda, @nomer_mesta, @kod_clients, @chislo_days, @date_oplati, @sale_oplata, @sale_season); SELECT nomer_kvitancii, date_broni, date_zaezda, nomer_mesta, kod_clients, chislo_days, date_oplati, sale_oplata, sale_season FROM bronirovenie WHERE (nomer_kvitancii = @nomer_kvitancii) SELECT nomer_kvitancii, date_broni, date_zaezda, nomer_mesta, kod_clients, chislo_days, date_oplati, sale_oplata, sale_season FROM dbo.bronirovenie UPDATE [dbo].[bronirovenie] SET [nomer_kvitancii] = @nomer_kvitancii, [date_broni] = @date_broni, [date_zaezda] = @date_zaezda, [nomer_mesta] = @nomer_mesta, [kod_clients] = @kod_clients, [chislo_days] = @chislo_days, [date_oplati] = @date_oplati, [sale_oplata] = @sale_oplata, [sale_season] = @sale_season WHERE (([nomer_kvitancii] = @Original_nomer_kvitancii) AND ((@IsNull_date_broni = 1 AND [date_broni] IS NULL) OR ([date_broni] = @Original_date_broni)) AND ((@IsNull_date_zaezda = 1 AND [date_zaezda] IS NULL) OR ([date_zaezda] = @Original_date_zaezda)) AND ((@IsNull_nomer_mesta = 1 AND [nomer_mesta] IS NULL) OR ([nomer_mesta] = @Original_nomer_mesta)) AND ((@IsNull_kod_clients = 1 AND [kod_clients] IS NULL) OR ([kod_clients] = @Original_kod_clients)) AND ((@IsNull_chislo_days = 1 AND [chislo_days] IS NULL) OR ([chislo_days] = @Original_chislo_days)) AND ((@IsNull_date_oplati = 1 AND [date_oplati] IS NULL) OR ([date_oplati] = @Original_date_oplati)) AND ((@IsNull_sale_oplata = 1 AND [sale_oplata] IS NULL) OR ([sale_oplata] = @Original_sale_oplata)) AND ((@IsNull_sale_season = 1 AND [sale_season] IS NULL) OR ([sale_season] = @Original_sale_season))); SELECT nomer_kvitancii, date_broni, date_zaezda, nomer_mesta, kod_clients, chislo_days, date_oplati, sale_oplata, sale_season FROM bronirovenie WHERE (nomer_kvitancii = @nomer_kvitancii)