题目内容

YouareresponsibleformanagingthedatabaseschemaforanorderentryapplicationinaSQLServer2005database.Afteradesignreview，amemberofthedevelopmentstaffasksyoutoaddanewcolumnnamedCommissionRatetotheProducttable.Becausetheactualcommissionratesforallproductsarenotknownatthistime，eachproducthasadefaultcommissionrateof12percent.Theratecanbemodifiedasnecessary.Youaddthenewcolumn.Youneedtoconfigurethetabletoassignthedefaultvalueasefficientlyaspossible.
Whatshouldyoudo？（）

查看答案

搜索结果不匹配？点我反馈

更多问题

YouareplanningtoimportcustomerdatafromtheCustomertableandtheCountrytableinyourSQLServer2000databaseintoaSQLServer2005database.Youwanttoensurethatduringtheimportprocess，eachvalueintheCountryCodecolumnoftheCustomertablehasacorrespondingrecordintheCountryCodecolumnintheCountrytableoftheSQLServer2005database.Youdefineaforeignkeybetweenthesetwotables.Thus，referentialintegritywillguaranteethattheimportroutinefailsifthereareanyrecordswhereaCountryCodevaluedoesnotexistintheCountrytablebutdoesexistintheCustomertable.YouneedtoensurethattheimportprocessdoesnotfailifrecordsareencounteredthatdonotexistintheCountrytable.
Whatshouldyoudo？（）

西安自参考答案：√周朝开始至唐，有十个王朝在此建都，故称十朝古都。（)

常见的调研报告一般包括哪几个部分？

科学的调研计划应包括哪些主要内容？