SELECT
[ExamResult_backup_20120913].[ID] AS [ID],
[ExamResult_backup_20120913].[user_id] AS [user_id],
[ExamResult_backup_20120913].[test_name] AS [test_name],
[ExamResult_backup_20120913].[test_paper_id] AS [test_paper_id],
[ExamResult_backup_20120913].[test_begin_date] AS [test_begin_date],
[ExamResult_backup_20120913].[test_end_date] AS [test_end_date],
[ExamResult_backup_20120913].[limited_minutes] AS [limited_minutes],
[ExamResult_backup_20120913].[test_address] AS [test_address],
[ExamResult_backup_20120913].[onlinetest_id] AS [onlinetest_id],
[ExamResult_backup_20120913].[OrgId] AS [OrgId],
[ExamResult_backup_20120913].[username] AS [username],
[ExamResult_backup_20120913].[score] AS [score],
[ExamResult_backup_20120913].[modifiy_sore] AS [modifiy_sore],
[ExamResult_backup_20120913].[is_auto_read] AS [is_auto_read],
[ExamResult_backup_20120913].[visible] AS [visible],
[ExamResult_backup_20120913].[is_man_read] AS [is_man_read],
[ExamResult_backup_20120913].[last_examination] AS [last_examination]
FROM [dbo].[ExamResult_backup_20120913] AS [ExamResult_backup_20120913]
SELECT
[MSreplication_objects].[publisher] AS [publisher],
[MSreplication_objects].[publisher_db] AS [publisher_db],
[MSreplication_objects].[publication] AS [publication],
[MSreplication_objects].[object_name] AS [object_name],
[MSreplication_objects].[object_type] AS [object_type],
[MSreplication_objects].[article] AS [article]
FROM [dbo].[MSreplication_objects] AS [MSreplication_objects]
SELECT
[MSreplication_subscriptions].[publisher] AS [publisher],
[MSreplication_subscriptions].[publisher_db] AS [publisher_db],
[MSreplication_subscriptions].[publication] AS [publication],
[MSreplication_subscriptions].[independent_agent] AS [independent_agent],
[MSreplication_subscriptions].[subscription_type] AS [subscription_type],
[MSreplication_subscriptions].[distribution_agent] AS [distribution_agent],
[MSreplication_subscriptions].[time] AS [time],
[MSreplication_subscriptions].[description] AS [description],
[MSreplication_subscriptions].[transaction_timestamp] AS [transaction_timestamp],
[MSreplication_subscriptions].[update_mode] AS [update_mode],
[MSreplication_subscriptions].[agent_id] AS [agent_id],
[MSreplication_subscriptions].[subscription_guid] AS [subscription_guid],
[MSreplication_subscriptions].[subid] AS [subid],
[MSreplication_subscriptions].[immediate_sync] AS [immediate_sync]
FROM [dbo].[MSreplication_subscriptions] AS [MSreplication_subscriptions]
SELECT
[MSsavedforeignkeycolumns].[program_name] AS [program_name],
[MSsavedforeignkeycolumns].[constraint_name] AS [constraint_name],
[MSsavedforeignkeycolumns].[parent_schema] AS [parent_schema],
[MSsavedforeignkeycolumns].[constraint_column_id] AS [constraint_column_id],
[MSsavedforeignkeycolumns].[referencing_column_name] AS [referencing_column_name],
[MSsavedforeignkeycolumns].[referenced_column_name] AS [referenced_column_name],
[MSsavedforeignkeycolumns].[timestamp] AS [timestamp]
FROM [dbo].[MSsavedforeignkeycolumns] AS [MSsavedforeignkeycolumns]
SELECT
[MSsavedforeignkeyextendedproperties].[program_name] AS [program_name],
[MSsavedforeignkeyextendedproperties].[constraint_name] AS [constraint_name],
[MSsavedforeignkeyextendedproperties].[parent_schema] AS [parent_schema],
[MSsavedforeignkeyextendedproperties].[property_name] AS [property_name],
[MSsavedforeignkeyextendedproperties].[timestamp] AS [timestamp]
FROM [dbo].[MSsavedforeignkeyextendedproperties] AS [MSsavedforeignkeyextendedproperties]
SELECT
[MSsavedforeignkeys].[program_name] AS [program_name],
[MSsavedforeignkeys].[constraint_name] AS [constraint_name],
[MSsavedforeignkeys].[parent_schema] AS [parent_schema],
[MSsavedforeignkeys].[parent_name] AS [parent_name],
[MSsavedforeignkeys].[referenced_object_schema] AS [referenced_object_schema],
[MSsavedforeignkeys].[referenced_object_name] AS [referenced_object_name],
[MSsavedforeignkeys].[is_disabled] AS [is_disabled],
[MSsavedforeignkeys].[is_not_for_replication] AS [is_not_for_replication],
[MSsavedforeignkeys].[is_not_trusted] AS [is_not_trusted],
[MSsavedforeignkeys].[delete_referential_action] AS [delete_referential_action],
[MSsavedforeignkeys].[update_referential_action] AS [update_referential_action],
[MSsavedforeignkeys].[timestamp] AS [timestamp]
FROM [dbo].[MSsavedforeignkeys] AS [MSsavedforeignkeys]
SELECT
[MSsnapshotdeliveryprogress].[session_token] AS [session_token],
[MSsnapshotdeliveryprogress].[progress_token_hash] AS [progress_token_hash],
[MSsnapshotdeliveryprogress].[progress_token] AS [progress_token],
[MSsnapshotdeliveryprogress].[progress_timestamp] AS [progress_timestamp]
FROM [dbo].[MSsnapshotdeliveryprogress] AS [MSsnapshotdeliveryprogress]
SELECT
[MSsubscription_agents].[id] AS [id],
[MSsubscription_agents].[publisher] AS [publisher],
[MSsubscription_agents].[publisher_db] AS [publisher_db],
[MSsubscription_agents].[publication] AS [publication],
[MSsubscription_agents].[subscription_type] AS [subscription_type],
[MSsubscription_agents].[queue_id] AS [queue_id],
[MSsubscription_agents].[update_mode] AS [update_mode],
[MSsubscription_agents].[failover_mode] AS [failover_mode],
[MSsubscription_agents].[spid] AS [spid],
[MSsubscription_agents].[login_time] AS [login_time],
[MSsubscription_agents].[allow_subscription_copy] AS [allow_subscription_copy],
[MSsubscription_agents].[attach_state] AS [attach_state],
[MSsubscription_agents].[attach_version] AS [attach_version],
[MSsubscription_agents].[last_sync_status] AS [last_sync_status],
[MSsubscription_agents].[last_sync_summary] AS [last_sync_summary],
[MSsubscription_agents].[last_sync_time] AS [last_sync_time],
[MSsubscription_agents].[queue_server] AS [queue_server]
FROM [dbo].[MSsubscription_agents] AS [MSsubscription_agents]
SELECT
[test_onlinetest_man].[ID] AS [ID],
[test_onlinetest_man].[onlinetest_id] AS [onlinetest_id],
[test_onlinetest_man].[user_id] AS [user_id],
[test_onlinetest_man].[OrgId] AS [OrgId],
[test_onlinetest_man].[name] AS [name],
[test_onlinetest_man].[username] AS [username],
[test_onlinetest_man].[sex] AS [sex],
[test_onlinetest_man].[mobile_num] AS [mobile_num],
[test_onlinetest_man].[created_by] AS [created_by],
[test_onlinetest_man].[created_date] AS [created_date],
[test_onlinetest_man].[loginCount] AS [loginCount],
[test_onlinetest_man].[lastLoginTime] AS [lastLoginTime],
[test_onlinetest_man].[beginTime] AS [beginTime],
[test_onlinetest_man].[endTime] AS [endTime],
[test_onlinetest_man].[limited_minutes] AS [limited_minutes],
[test_onlinetest_man].[state] AS [state],
[test_onlinetest_man].[warning_count] AS [warning_count],
[test_onlinetest_man].[lastModified] AS [lastModified],
[test_onlinetest_man].[relogin_count] AS [relogin_count],
[test_onlinetest_man].[time_of_filling] AS [time_of_filling],
[test_onlinetest_man].[filled] AS [filled]
FROM [dbo].[test_onlinetest_man] AS [test_onlinetest_man]
SELECT
[v_question].[question_json] AS [question_json],
[v_question].[test_question_Id] AS [test_question_Id],
[v_question].[base_question_type_id] AS [base_question_type_id],
[v_question].[test_paper_id] AS [test_paper_id],
[v_question].[order ] AS [order ]
FROM [dbo].[v_question] AS [v_question]
SELECT
[V_StudentEducationMissionClass].[EducationMissionClassID] AS [EducationMissionClassID],
[V_StudentEducationMissionClass].[EducationMissionClassName] AS [EducationMissionClassName],
[V_StudentEducationMissionClass].[CoursematerialID] AS [CoursematerialID],
[V_StudentEducationMissionClass].[CourseName] AS [CourseName],
[V_StudentEducationMissionClass].[CoverUrl] AS [CoverUrl],
[V_StudentEducationMissionClass].[UserID] AS [UserID],
[V_StudentEducationMissionClass].[SchoolyearID] AS [SchoolyearID],
[V_StudentEducationMissionClass].[TeacherID] AS [TeacherID]
FROM [dbo].[V_StudentEducationMissionClass] AS [V_StudentEducationMissionClass]
SELECT
[v_test_question].[rid] AS [rid],
[v_test_question].[test_question_Id] AS [test_question_Id],
[v_test_question].[base_question_type_id] AS [base_question_type_id],
[v_test_question].[content] AS [content],
[v_test_question].[question_file_id] AS [question_file_id],
[v_test_question].[question_type_name] AS [question_type_name],
[v_test_question].[questione_lib_name] AS [questione_lib_name],
[v_test_question].[difficulty_degree] AS [difficulty_degree],
[v_test_question].[answers] AS [answers],
[v_test_question].[is_order] AS [is_order],
[v_test_question].[answers_note] AS [answers_note],
[v_test_question].[note] AS [note],
[v_test_question].[test_question_libary_id] AS [test_question_libary_id],
[v_test_question].[used_count] AS [used_count],
[v_test_question].[right_percent] AS [right_percent],
[v_test_question].[is_vaild] AS [is_vaild],
[v_test_question].[created_date] AS [created_date],
[v_test_question].[wrong_count] AS [wrong_count],
[v_test_question].[score] AS [score],
[v_test_question].[filled] AS [filled],
[v_test_question].[time_of_filling] AS [time_of_filling],
[v_test_question].[created_by] AS [created_by],
[v_test_question].[wrong_percent] AS [wrong_percent]
FROM [dbo].[v_test_question] AS [v_test_question]
SELECT
[VTestQestion].[rid] AS [rid],
[VTestQestion].[test_question_Id] AS [test_question_Id],
[VTestQestion].[base_question_type_id] AS [base_question_type_id],
[VTestQestion].[content] AS [content],
[VTestQestion].[question_file_id] AS [question_file_id],
[VTestQestion].[question_type_name] AS [question_type_name],
[VTestQestion].[questione_lib_name] AS [questione_lib_name],
[VTestQestion].[difficulty_degree] AS [difficulty_degree],
[VTestQestion].[answers] AS [answers],
[VTestQestion].[is_order] AS [is_order],
[VTestQestion].[answers_note] AS [answers_note],
[VTestQestion].[note] AS [note],
[VTestQestion].[test_question_libary_id] AS [test_question_libary_id],
[VTestQestion].[used_count] AS [used_count],
[VTestQestion].[right_percent] AS [right_percent],
[VTestQestion].[is_vaild] AS [is_vaild],
[VTestQestion].[created_date] AS [created_date],
[VTestQestion].[wrong_count] AS [wrong_count],
[VTestQestion].[score] AS [score],
[VTestQestion].[filled] AS [filled],
[VTestQestion].[time_of_filling] AS [time_of_filling],
[VTestQestion].[created_by] AS [created_by],
[VTestQestion].[wrong_percent] AS [wrong_percent]
FROM [dbo].[VTestQestion] AS [VTestQestion]