DELETE FROM [dbo].[Ocenka] WHERE (([ID_studenta] = @Original_ID_studenta) AND ((@IsNull_Data_ikzamena1 = 1 AND [Data_ikzamena1] IS NULL) OR ([Data_ikzamena1] = @Original_Data_ikzamena1)) AND ((@IsNull_ID_predmeta1 = 1 AND [ID_predmeta1] IS NULL) OR ([ID_predmeta1] = @Original_ID_predmeta1)) AND ((@IsNull_Ocenka1 = 1 AND [Ocenka1] IS NULL) OR ([Ocenka1] = @Original_Ocenka1)) AND ((@IsNull_Data_ikzamena2 = 1 AND [Data_ikzamena2] IS NULL) OR ([Data_ikzamena2] = @Original_Data_ikzamena2)) AND ((@IsNull_ID_predmeta2 = 1 AND [ID_predmeta2] IS NULL) OR ([ID_predmeta2] = @Original_ID_predmeta2)) AND ((@IsNull_Ocenka2 = 1 AND [Ocenka2] IS NULL) OR ([Ocenka2] = @Original_Ocenka2)) AND ((@IsNull_Data_ikzamena3 = 1 AND [Data_ikzamena3] IS NULL) OR ([Data_ikzamena3] = @Original_Data_ikzamena3)) AND ((@IsNull_ID_predmeta3 = 1 AND [ID_predmeta3] IS NULL) OR ([ID_predmeta3] = @Original_ID_predmeta3)) AND ((@IsNull_Ocenka3 = 1 AND [Ocenka3] IS NULL) OR ([Ocenka3] = @Original_Ocenka3)) AND ((@IsNull_Srednii_ball = 1 AND [Srednii_ball] IS NULL) OR ([Srednii_ball] = @Original_Srednii_ball))) INSERT INTO [dbo].[Ocenka] ([Data_ikzamena1], [ID_predmeta1], [Ocenka1], [Data_ikzamena2], [ID_predmeta2], [Ocenka2], [Data_ikzamena3], [ID_predmeta3], [Ocenka3], [Srednii_ball]) VALUES (@Data_ikzamena1, @ID_predmeta1, @Ocenka1, @Data_ikzamena2, @ID_predmeta2, @Ocenka2, @Data_ikzamena3, @ID_predmeta3, @Ocenka3, @Srednii_ball); SELECT ID_studenta, Data_ikzamena1, ID_predmeta1, Ocenka1, Data_ikzamena2, ID_predmeta2, Ocenka2, Data_ikzamena3, ID_predmeta3, Ocenka3, Srednii_ball FROM Ocenka WHERE (ID_studenta = SCOPE_IDENTITY()) SELECT ID_studenta, Data_ikzamena1, ID_predmeta1, Ocenka1, Data_ikzamena2, ID_predmeta2, Ocenka2, Data_ikzamena3, ID_predmeta3, Ocenka3, Srednii_ball FROM dbo.Ocenka UPDATE [dbo].[Ocenka] SET [Data_ikzamena1] = @Data_ikzamena1, [ID_predmeta1] = @ID_predmeta1, [Ocenka1] = @Ocenka1, [Data_ikzamena2] = @Data_ikzamena2, [ID_predmeta2] = @ID_predmeta2, [Ocenka2] = @Ocenka2, [Data_ikzamena3] = @Data_ikzamena3, [ID_predmeta3] = @ID_predmeta3, [Ocenka3] = @Ocenka3, [Srednii_ball] = @Srednii_ball WHERE (([ID_studenta] = @Original_ID_studenta) AND ((@IsNull_Data_ikzamena1 = 1 AND [Data_ikzamena1] IS NULL) OR ([Data_ikzamena1] = @Original_Data_ikzamena1)) AND ((@IsNull_ID_predmeta1 = 1 AND [ID_predmeta1] IS NULL) OR ([ID_predmeta1] = @Original_ID_predmeta1)) AND ((@IsNull_Ocenka1 = 1 AND [Ocenka1] IS NULL) OR ([Ocenka1] = @Original_Ocenka1)) AND ((@IsNull_Data_ikzamena2 = 1 AND [Data_ikzamena2] IS NULL) OR ([Data_ikzamena2] = @Original_Data_ikzamena2)) AND ((@IsNull_ID_predmeta2 = 1 AND [ID_predmeta2] IS NULL) OR ([ID_predmeta2] = @Original_ID_predmeta2)) AND ((@IsNull_Ocenka2 = 1 AND [Ocenka2] IS NULL) OR ([Ocenka2] = @Original_Ocenka2)) AND ((@IsNull_Data_ikzamena3 = 1 AND [Data_ikzamena3] IS NULL) OR ([Data_ikzamena3] = @Original_Data_ikzamena3)) AND ((@IsNull_ID_predmeta3 = 1 AND [ID_predmeta3] IS NULL) OR ([ID_predmeta3] = @Original_ID_predmeta3)) AND ((@IsNull_Ocenka3 = 1 AND [Ocenka3] IS NULL) OR ([Ocenka3] = @Original_Ocenka3)) AND ((@IsNull_Srednii_ball = 1 AND [Srednii_ball] IS NULL) OR ([Srednii_ball] = @Original_Srednii_ball))); SELECT ID_studenta, Data_ikzamena1, ID_predmeta1, Ocenka1, Data_ikzamena2, ID_predmeta2, Ocenka2, Data_ikzamena3, ID_predmeta3, Ocenka3, Srednii_ball FROM Ocenka WHERE (ID_studenta = @ID_studenta) DELETE FROM [dbo].[Predmet] WHERE (([ID_predmeta] = @Original_ID_predmeta) AND ((@IsNull_Nazvanie_predmeta = 1 AND [Nazvanie_predmeta] IS NULL) OR ([Nazvanie_predmeta] = @Original_Nazvanie_predmeta))) INSERT INTO [dbo].[Predmet] ([Nazvanie_predmeta], [Opisanie_predmeta]) VALUES (@Nazvanie_predmeta, @Opisanie_predmeta); SELECT ID_predmeta, Nazvanie_predmeta, Opisanie_predmeta FROM Predmet WHERE (ID_predmeta = SCOPE_IDENTITY()) SELECT ID_predmeta, Nazvanie_predmeta, Opisanie_predmeta FROM dbo.Predmet UPDATE [dbo].[Predmet] SET [Nazvanie_predmeta] = @Nazvanie_predmeta, [Opisanie_predmeta] = @Opisanie_predmeta WHERE (([ID_predmeta] = @Original_ID_predmeta) AND ((@IsNull_Nazvanie_predmeta = 1 AND [Nazvanie_predmeta] IS NULL) OR ([Nazvanie_predmeta] = @Original_Nazvanie_predmeta))); SELECT ID_predmeta, Nazvanie_predmeta, Opisanie_predmeta FROM Predmet WHERE (ID_predmeta = @ID_predmeta) DELETE FROM [dbo].[Specialnost] WHERE (([ID_specialnosti] = @Original_ID_specialnosti) AND ((@IsNull_Nazvanie_specialnosti = 1 AND [Nazvanie_specialnosti] IS NULL) OR ([Nazvanie_specialnosti] = @Original_Nazvanie_specialnosti))) INSERT INTO [dbo].[Specialnost] ([Nazvanie_specialnosti], [Opisanie_specialnosti]) VALUES (@Nazvanie_specialnosti, @Opisanie_specialnosti); SELECT ID_specialnosti, Nazvanie_specialnosti, Opisanie_specialnosti FROM Specialnost WHERE (ID_specialnosti = SCOPE_IDENTITY()) SELECT ID_specialnosti, Nazvanie_specialnosti, Opisanie_specialnosti FROM dbo.Specialnost UPDATE [dbo].[Specialnost] SET [Nazvanie_specialnosti] = @Nazvanie_specialnosti, [Opisanie_specialnosti] = @Opisanie_specialnosti WHERE (([ID_specialnosti] = @Original_ID_specialnosti) AND ((@IsNull_Nazvanie_specialnosti = 1 AND [Nazvanie_specialnosti] IS NULL) OR ([Nazvanie_specialnosti] = @Original_Nazvanie_specialnosti))); SELECT ID_specialnosti, Nazvanie_specialnosti, Opisanie_specialnosti FROM Specialnost WHERE (ID_specialnosti = @ID_specialnosti) DELETE FROM [dbo].[Student] WHERE (([ID_studenta] = @Original_ID_studenta) AND ((@IsNull_FIO = 1 AND [FIO] IS NULL) OR ([FIO] = @Original_FIO)) AND ([pol] = @Original_pol) AND ((@IsNull_Data_pojdeniya = 1 AND [Data_pojdeniya] IS NULL) OR ([Data_pojdeniya] = @Original_Data_pojdeniya)) AND ((@IsNull_roditeli = 1 AND [roditeli] IS NULL) OR ([roditeli] = @Original_roditeli)) AND ((@IsNull_telephone = 1 AND [telephone] IS NULL) OR ([telephone] = @Original_telephone)) AND ((@IsNull_Nomer_zachetki = 1 AND [Nomer_zachetki] IS NULL) OR ([Nomer_zachetki] = @Original_Nomer_zachetki)) AND ((@IsNull_Data_postypleniya = 1 AND [Data_postypleniya] IS NULL) OR ([Data_postypleniya] = @Original_Data_postypleniya)) AND ((@IsNull_Gryppa = 1 AND [Gryppa] IS NULL) OR ([Gryppa] = @Original_Gryppa)) AND ((@IsNull_Kypc = 1 AND [Kypc] IS NULL) OR ([Kypc] = @Original_Kypc)) AND ((@IsNull_ID_sresialnostu = 1 AND [ID_sresialnostu] IS NULL) OR ([ID_sresialnostu] = @Original_ID_sresialnostu)) AND ((@p3 = 1 AND [ochnay forma obycheniya]]] IS NULL) OR ([ochnay forma obycheniya]]] = @p2))) INSERT INTO [dbo].[Student] ([ID_studenta], [FIO], [pol], [Data_pojdeniya], [roditeli], [adres], [telephone], [Pasportnie_dannie], [Nomer_zachetki], [Data_postypleniya], [Gryppa], [Kypc], [ID_sresialnostu], [ochnay forma obycheniya]]]) VALUES (@ID_studenta, @FIO, @pol, @Data_pojdeniya, @roditeli, @adres, @telephone, @Pasportnie_dannie, @Nomer_zachetki, @Data_postypleniya, @Gryppa, @Kypc, @ID_sresialnostu, @p1); SELECT ID_studenta, FIO, pol, Data_pojdeniya, roditeli, adres, telephone, Pasportnie_dannie, Nomer_zachetki, Data_postypleniya, Gryppa, Kypc, ID_sresialnostu, [ochnay forma obycheniya]]] FROM Student WHERE (ID_studenta = @ID_studenta) SELECT ID_studenta, FIO, pol, Data_pojdeniya, roditeli, adres, telephone, Pasportnie_dannie, Nomer_zachetki, Data_postypleniya, Gryppa, Kypc, ID_sresialnostu, [ochnay forma obycheniya]]] FROM dbo.Student UPDATE [dbo].[Student] SET [ID_studenta] = @ID_studenta, [FIO] = @FIO, [pol] = @pol, [Data_pojdeniya] = @Data_pojdeniya, [roditeli] = @roditeli, [adres] = @adres, [telephone] = @telephone, [Pasportnie_dannie] = @Pasportnie_dannie, [Nomer_zachetki] = @Nomer_zachetki, [Data_postypleniya] = @Data_postypleniya, [Gryppa] = @Gryppa, [Kypc] = @Kypc, [ID_sresialnostu] = @ID_sresialnostu, [ochnay forma obycheniya]]] = @p1 WHERE (([ID_studenta] = @Original_ID_studenta) AND ((@IsNull_FIO = 1 AND [FIO] IS NULL) OR ([FIO] = @Original_FIO)) AND ([pol] = @Original_pol) AND ((@IsNull_Data_pojdeniya = 1 AND [Data_pojdeniya] IS NULL) OR ([Data_pojdeniya] = @Original_Data_pojdeniya)) AND ((@IsNull_roditeli = 1 AND [roditeli] IS NULL) OR ([roditeli] = @Original_roditeli)) AND ((@IsNull_telephone = 1 AND [telephone] IS NULL) OR ([telephone] = @Original_telephone)) AND ((@IsNull_Nomer_zachetki = 1 AND [Nomer_zachetki] IS NULL) OR ([Nomer_zachetki] = @Original_Nomer_zachetki)) AND ((@IsNull_Data_postypleniya = 1 AND [Data_postypleniya] IS NULL) OR ([Data_postypleniya] = @Original_Data_postypleniya)) AND ((@IsNull_Gryppa = 1 AND [Gryppa] IS NULL) OR ([Gryppa] = @Original_Gryppa)) AND ((@IsNull_Kypc = 1 AND [Kypc] IS NULL) OR ([Kypc] = @Original_Kypc)) AND ((@IsNull_ID_sresialnostu = 1 AND [ID_sresialnostu] IS NULL) OR ([ID_sresialnostu] = @Original_ID_sresialnostu)) AND ((@p3 = 1 AND [ochnay forma obycheniya]]] IS NULL) OR ([ochnay forma obycheniya]]] = @p2))); SELECT ID_studenta, FIO, pol, Data_pojdeniya, roditeli, adres, telephone, Pasportnie_dannie, Nomer_zachetki, Data_postypleniya, Gryppa, Kypc, ID_sresialnostu, [ochnay forma obycheniya]]] FROM Student WHERE (ID_studenta = @ID_studenta) SELECT FIO, pol, [ochnay forma obycheniya]]], Kypc, Gryppa, Data_postypleniya, telephone, Pasportnie_dannie, adres, Data_pojdeniya, roditeli, Nazvanie_specialnosti, Opisanie_specialnosti, Nomer_zachetki FROM dbo.View_1 SELECT FIO, pol, [ochnay forma obycheniya]]], Kypc, Gryppa, Nomer_zachetki, Data_postypleniya, telephone, Pasportnie_dannie, adres, roditeli, Data_pojdeniya, Nazvanie_specialnosti, Opisanie_specialnosti FROM dbo.[Запрос Студент+специальность] SELECT FIO, Data_ikzamena1, Ocenka1, Data_ikzamena2, Ocenka2, Data_ikzamena3, Ocenka3, Srednii_ball, Nazvanie_predmeta, Expr1, Expr2 FROM dbo.[Запрос студенты+оценки] SELECT FIO, pol, [ochnay forma obycheniya]]], Kypc, Gryppa, Data_postypleniya, telephone, Pasportnie_dannie, adres, Data_pojdeniya, roditeli, Nazvanie_specialnosti, Opisanie_specialnosti, Nomer_zachetki, Expr1 FROM dbo.[Фильтр BY] SELECT FIO, pol, [ochnay forma obycheniya]]], Kypc, Gryppa, Data_postypleniya, telephone, Pasportnie_dannie, adres, Data_pojdeniya, roditeli, Nazvanie_specialnosti, Opisanie_specialnosti, Nomer_zachetki, Expr1 FROM dbo.[Фильтр MO] SELECT FIO, pol, [ochnay forma obycheniya]]], Kypc, Gryppa, telephone, Data_postypleniya, Pasportnie_dannie, adres, Data_pojdeniya, roditeli, Nazvanie_specialnosti, Opisanie_specialnosti, Nomer_zachetki FROM dbo.[Фильтр PI] SELECT FIO, pol, [ochnay forma obycheniya]]], Kypc, Gryppa, Data_postypleniya, telephone, Pasportnie_dannie, adres, Data_pojdeniya, Nazvanie_specialnosti, roditeli, Nomer_zachetki, Opisanie_specialnosti FROM dbo.[Фильтр ST] SELECT FIO, pol, [ochnay forma obycheniya]]], Kypc, Gryppa, Data_postypleniya, telephone, Pasportnie_dannie, adres, Data_pojdeniya, roditeli, Nazvanie_specialnosti, Opisanie_specialnosti, Nomer_zachetki, Expr1 FROM dbo.[Фильтр мать] SELECT FIO, pol, [ochnay forma obycheniya]]], Kypc, Gryppa, Data_postypleniya, telephone, Pasportnie_dannie, adres, Data_pojdeniya, roditeli, Nazvanie_specialnosti, Opisanie_specialnosti, Nomer_zachetki FROM dbo.[фильтр ММ] SELECT FIO, pol, [ochnay forma obycheniya]]], Kypc, Gryppa, Data_postypleniya, telephone, Pasportnie_dannie, adres, Data_pojdeniya, roditeli, Nazvanie_specialnosti, Opisanie_specialnosti, Nomer_zachetki, Expr1 FROM dbo.[Фильтр отец] SELECT FIO, pol, [ochnay forma obycheniya]]], Kypc, Gryppa, Data_postypleniya, telephone, Pasportnie_dannie, adres, Data_pojdeniya, roditeli, Nazvanie_specialnosti, Opisanie_specialnosti, Nomer_zachetki, Expr1 FROM dbo.[Фильтр отец и мать]