Автоматизация проверки знаний и навыков студентов в области прикладной математики и информатики
Дипломная работа - Компьютеры, программирование
Другие дипломы по предмету Компьютеры, программирование
deleted,Tests," = "," AND") */.Question_test_id = Tests.Test_ID ANDEXISTS (* FROM Questions
/* %JoinFKPK(Questions,Tests," = "," AND") */.Question_test_id = Tests.Test_ID
)
)@errno = 30010,
@errmsg = Cannot delete last Questions because Tests exists.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */:@errno @errmsgtransaction
TRIGGER tU_Questions ON Questions FOR UPDATE AS
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* UPDATE trigger on Questions */@NUMROWS int,
@nullcnt int,
@validcnt int,
@insQuestion_id int,
@errno int,
@errmsg varchar(255)
@NUMROWS = @@rowcount
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Questions R/6 Answers on parent update no action */
/* ERWIN_RELATION:CHECKSUM="00026fe1", PARENT_OWNER="", PARENT_TABLE="Questions"_OWNER="", CHILD_TABLE="Answers"C_VERB_PHRASE="R/6", C2P_VERB_PHRASE="R/6", _CONSTRAINT="R_6", FK_COLUMNS="Answer_question_id" */
/* %ParentPK(" OR",UPDATE) */(Question_id)EXISTS (* FROM deleted,Answers
/* %JoinFKPK(Answers,deleted," = "," AND") */.Answer_question_id = deleted.Question_id
)@errno = 30005,
@errmsg = Cannot update Questions because Answers exists.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Tests R/5 Questions on child update no action */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="Tests"_OWNER="", CHILD_TABLE="Questions"C_VERB_PHRASE="R/5", C2P_VERB_PHRASE="R/5", _CONSTRAINT="R_5", FK_COLUMNS="Question_test_id" */
/* %ChildFK(" OR",UPDATE) */(Question_test_id)@nullcnt = 0@validcnt = count(*)inserted,Tests
/* %JoinFKPK(inserted,Tests) */.Question_test_id = Tests.Test_ID
/* %NotnullFK(inserted," IS NULL","select @nullcnt = count(*) from inserted where"," AND") */
@validcnt + @nullcnt != @NUMROWS@errno = 30007,
@errmsg = Cannot update Questions because Tests does not exist.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */:@errno @errmsgtransaction
TRIGGER tD_Sections ON Sections FOR DELETE AS
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* DELETE trigger on Sections */@errno int,
@errmsg varchar(255)
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Sections R/8 Tests on parent delete cascade */
/* ERWIN_RELATION:CHECKSUM="00019e4b", PARENT_OWNER="", PARENT_TABLE="Sections"_OWNER="", CHILD_TABLE="Tests"C_VERB_PHRASE="R/8", C2P_VERB_PHRASE="R/8", _CONSTRAINT="R_8", FK_COLUMNS="Test_section_ID" */TestsTests,deleted
/* %JoinFKPK(Tests,deleted," = "," AND") */.Test_section_ID = deleted.Section_id
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Sections R/9 Group_sections on parent delete cascade */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="Sections"_OWNER="", CHILD_TABLE="Group_sections"C_VERB_PHRASE="R/9", C2P_VERB_PHRASE="R/9", _CONSTRAINT="R_9", FK_COLUMNS="Gs_section_id" */Group_sectionsGroup_sections,deleted
/* %JoinFKPK(Group_sections,deleted," = "," AND") */_sections.Gs_section_id = deleted.Section_id
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */:@errno @errmsgtransactionTRIGGER tU_Sections ON Sections FOR UPDATE AS
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* UPDATE trigger on Sections */@NUMROWS int,
@nullcnt int,
@validcnt int,
@insSection_id int,
@errno int,
@errmsg varchar(255)
@NUMROWS = @@rowcount
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Sections R/8 Tests on parent update no action */
/* ERWIN_RELATION:CHECKSUM="00022bb1", PARENT_OWNER="", PARENT_TABLE="Sections"_OWNER="", CHILD_TABLE="Tests"C_VERB_PHRASE="R/8", C2P_VERB_PHRASE="R/8", _CONSTRAINT="R_8", FK_COLUMNS="Test_section_ID" */
/* %ParentPK(" OR",UPDATE) */(Section_id)EXISTS (* FROM deleted,Tests
/* %JoinFKPK(Tests,deleted," = "," AND") */.Test_section_ID = deleted.Section_id
)@errno = 30005,
@errmsg = Cannot update Sections because Tests exists.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Sections R/9 Group_sections on parent update no action */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="Sections"_OWNER="", CHILD_TABLE="Group_sections"C_VERB_PHRASE="R/9", C2P_VERB_PHRASE="R/9", _CONSTRAINT="R_9", FK_COLUMNS="Gs_section_id" */
/* %ParentPK(" OR",UPDATE) */(Section_id)EXISTS (* FROM deleted,Group_sections
/* %JoinFKPK(Group_sections,deleted," = "," AND") */_sections.Gs_section_id = deleted.Section_id
)@errno = 30005,
@errmsg = Cannot update Sections because Group_sections exists.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */:@errno @errmsgtransaction
TRIGGER tD_Tests ON Tests FOR DELETE AS
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* DELETE trigger on Tests */@errno int,
@errmsg varchar(255)
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Tests R/5 Questions on parent delete cascade */
/* ERWIN_RELATION:CHECKSUM="0002ff97", PARENT_OWNER="", PARENT_TABLE="Tests"_OWNER="", CHILD_TABLE="Questions"C_VERB_PHRASE="R/5", C2P_VERB_PHRASE="R/5", _CONSTRAINT="R_5", FK_COLUMNS="Question_test_id" */QuestionsQuestions,deleted
/* %JoinFKPK(Questions,deleted," = "," AND") */.Question_test_id = deleted.Test_ID
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Tests R/15 User_results on parent delete no action */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="Tests"_OWNER="", CHILD_TABLE="User_results"C_VERB_PHRASE="R/15", C2P_VERB_PHRASE="R/15", _CONSTRAINT="R_15", FK_COLUMNS="User_result_test_id" */EXISTS (* FROM deleted,User_results
/* %JoinFKPK(User_results,deleted," = "," AND") */_results.User_result_test_id = deleted.Test_ID
)@errno = 30001,
@errmsg = Cannot delete Tests because User_results exists.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Sections R/8 Tests on child delete no action */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="Sections"_OWNER="", CHILD_TABLE="Tests"C_VERB_PHRASE="R/8", C2P_VERB_PHRASE="R/8", _CONSTRAINT="R_8", FK_COLUMNS="Test_section_ID" */EXISTS (SELECT * FROM deleted,Sections
/* %JoinFKPK(deleted,Sections," = "," AND") */.Test_section_ID = Sections.Section_id ANDEXISTS (* FROM Tests
/* %JoinFKPK(Tests,Sections," = "," AND") */.Test_section_ID = Sections.Section_id
)
)@errno = 30010,
@errmsg = Cannot delete last Tests because Sections exists.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */:@errno @errmsgtransactionTRIGGER tU_Tests ON Tests FOR UPDATE AS
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* UPDATE trigger on Tests */@NUMROWS int,
@nullcnt int,
@validcnt int,
@insTest_ID int,
@errno int,
@errmsg varchar(255)@NUMROWS = @@rowcount
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Tests R/5 Questions on parent update no action */
/* ERWIN_RELATION:CHECKSUM="0003c096", PARENT_OWNER="", PARENT_TABLE="Tests"_OWNER="", CHILD_TABLE="Questions"C_VERB_PHRASE="R/5", C2P_VERB_PHRASE="R/5", _CONSTRAINT="R_5", FK_COLUMNS="Question_test_id" */
/* %ParentPK(" OR",UPDATE) */(Test_ID)EXISTS (* FROM deleted,Questions
/* %JoinFKPK(Questions,deleted," = "," AND") */.Question_test_id = deleted.Test_ID
)@errno = 30005,
@errmsg = Cannot update Tests because Questions exists.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Tests R/15 User_results on parent update no action */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="Tests"_OWNER="", CHILD_TABLE="User_results"C_VERB_PHRASE="R/15", C2P_VERB_PHRASE="R/15", _CONSTRAINT="R_15", FK_COLUMNS="User_result_test_id" */
/* %ParentPK(" OR",UPDATE) */(Test_ID)EXISTS (* FROM deleted,User_results
/* %JoinFKPK(User_results,deleted," = "," AND") */_results.User_result_test_id = delet