【单选题】You are the administrator of a SQL Server 2000 computer. One of the databases on the server contains a table named complaints. This table is used to store information about customer complaints. The cu...
A.
Create an UPDATE trigger that sends an e-mail message.
B.
Create a stored procedure that sends an e-mail message. Use the stored procedures to make changes to the data.
C.
Create a user-defined function that sends an e-mail message. Use the function to make changes to the data.
D.
Create a rule that validates data entry. Bind the rule to the CompliantClosed column.
【判断题】Short simple sentences are often used to make emphatic or important statements while long complex sentences express complex ideas clearly and accurately.
【单选题】You are the database administrator for an accounting company. You are installing SQL Server 2000 on a new Microsoft Windows 2000 Server computer. The computer will run two client/server database appli...
A.
Rerun the SQL Server Setup and specify the SQL_Latin1_General_CP437_BIN collation.
B.
Run the rebuildm utility and specify the SQL_Latin1_General_CP437_BIN collation.
C.
Use the ALTER DATABASE statement to specify the SQL_Latin1_General_CP437_BIN collation for the Financials database.
D.
Use the ALTER TABLE statement to specify the SQL_Latin1_General_CP437_BIN collation for each table in the Financials database.