试题详情
单项选择题 You are responsible for managing a SQL Server 2005 database that stores sales information. Many values in nchar columns in the database tables contain preceding or trailing spaces. You need to implement a mechanism that selects the data from the tables without leading and trailing spaces. Your solution must be available for reuse in Transact-SQL statements and views. What should you do？（）

A、Create DML triggers that query the inserted and deleted tables.

B、Create a stored procedure that calls the LTRIM and RTRIM built-in functions.

C、Create a Transact-SQL function that calls the LTRIM and RTRIM built-in functions.

D、Call the TRIM built-in function.

  • C

  • 关注下方微信公众号，在线模考后查看

热门试题