單項(xiàng)選擇題

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.

你可能感興趣的試題

多項(xiàng)選擇題

TestKing.com Web site includes a page that customers use to send feedback about the company and its products. You use a SQL Server 2005 database to store the comments in the Comments column of a table named Feedback. You need to implement full-text searching so that you can run reports on the comments.
Which two actions should you perform？（）

A.Create a nonclustered index on the Comments column.
B.Execute the USE Master Transact-SQL statement.
C.Create a full-text catalog.
D.Create a full-text index on the Comments column.

單項(xiàng)選擇題

You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort.
What should you do？（）

A.Define the new column as NULL.Update the FriendlyName column to the same value as the productName column. Alter the FriendlyName column to be NOT NULL.
B.Define the new column as NOT NULL with a default value of ’Undefined.’
C.Define the new column as NULL. Use application logic to enforce the data constraint.
D.Define the new column as NULL with a default value of ’Undefined.’

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

你可能感興趣的試題

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精