你负责管理一个存储销售信息的SQL SERVER 2005数据库。在数据库中许多表都包含nchar类型的列,并且这些列存储的值前后都包含有空格字符。为此,你需要一种机制(办法),在从表选择数据的时候去掉前后的空格字符。要求,你的解决方案对所有SQL语句或视图都是可重用的。你应该怎么做?()
A.
创建一个insert和delete操作的DML触发器
B.
创建一个去调用LTRIM和RTRIM的存储过程
C.
创建一个去调用LTRIM和RTRIM的用户定义函数
D.
创建一个调用TRIM的用户定义函数
拍照语音搜题,微信中搜索"皮皮学"使用
参考答案:
参考解析:
知识点:
皮皮学刷刷变学霸
举一反三
【单选题】Network management helps you to(66)the strengths and weaknesses of your network, as well as determine any configuration changes that may be necessary. Any controlled changes to your network and its co...
【单选题】You are the administrator of a Windows 2000 Active Directory network. The network consists of a single domain. The domain includes 20 Windows NT Workstation 4.0 client computers. All other client comp...
A.
Modify the Windows NT policy template file so that you can restrict access to both My Network Places and Network Neighborhood. Save the policy file on the Terminal Server.
B.
Copy the Windows NT policy file to the 20 Windows NT Workstation computers.
C.
Create a Windows 2000 Group Policy that denies user access to My Network Places.
D.
Edit the local registry on the Windows NT Workstation computers to deny access to Entire Network in Network Neighborhood.
【多选题】You are the network administrator for Ezonexam. The network includes a Microsoft Windows NT Server 4.0 member server computer that has a non-Plug and Play ISA network adapter. You want to upgrade this...
A.
Install the latest driver for the network adapter.
B.
Disable the network adapter.
C.
Start the upgrade process by using Winnt32.exe
D.
Start the upgrade process by booting from the Windows 2000 Server compact disc.
E.
Configure BIOS to reserve the IRQ currently in use by the network adapter.
F.
Press F6 at the beginning of the text mode setup to specify an additional driver.
【单选题】You are the network administrator for Ezonexam. The network consists of a single Active Directory domain Ezonexam.com. All network servers run Windows Server 2000. Your network includes a shared folde...
A.
Modify the share permissions to remove the All - Read permission on EzonexamDocs from the Users group.
B.
Modify the NTFS permissions to remove the Allow - Read permissions on EzonexamDocs from the Users group.