网友您好, 请在下方输入框内输入要搜索的题目:
YouareresponsibleformanagingaSQLServer2005databasethatstoressalesinformation.Manyvaluesinncharcolumnsinthedatabasetablescontainprecedingortrailingspaces.Youneedtoimplementamechanismthatselectsthedatafromthetableswithoutleadingandtrailingspaces.YoursolutionmustbeavailableforreuseinTransact-SQLstatementsandviews.Whatshouldyoudo?()
A.CreateDMLtriggersthatquerytheinsertedanddeletedtables.
B.CreateastoredprocedurethatcallstheLTRIMandRTRIMbuilt-infunctions.
C.CreateaTransact-SQLfunctionthatcallstheLTRIMandRTRIMbuilt-infunctions.
D.CalltheTRIMbuilt-infunction.
参考答案