70-761

You create a table named Products by running the following Transact-SQL statement: You have the following stored procedure: You need to modify the stored procedure to meet the following new requirements: - Insert product records as a single unit of work. - Return error number 51000 when a product fails...

HOTSPOT You run the following Transact-SQL statement: You need to ensure that you can insert data into the table. What are the characteristics of the data? To answer, select the appropriate options in the answer area. View AnswerAnswer:

CORRECT TEXT You create a table named Sales.Orders by running the following Transact-SQL statement: You need to write a query that meets the following requirements: - removes orders from the table that were placed before January 1, 2012 - uses the date format of YYYYMMDD - ensures that the order...

DRAG DROP You have a database that tracks orders and deliveries for customers in North America. System versioning is enabled for all tables. The database contains the Sales.Customers, Application. Cities, and Sales. CustomerCategories tables. Details for the Sales.Customers table are shown in the following table: Details for the Application.Cities table...

You have a database that contains tables named Customer_CRMSystem and Customer_ HRSystem. Both tables use the following structure: The tables include the following records: Customer_ CRMSystem Customer_ HRSystem Records that contain null values for CustomerCode can be uniquely identified by Customer Name. You need to display customers who appear in...

HOTSPOT You have the following Transact-SQL query: What type of functions are used in the query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer:

DRAG DROP You need to create a stored procedure to update a table named Sales.Customers. The structure of the table is shown in the exhibit. (Click the exhibit button.) The stored procedure must meet the following requirements: - Accept two input parameters. - Update the company name if the customer...

DRAG DROP You need to create a stored procedure that meets the following requirements: - Produces a warning if the credit limit parameter is greater than 7,000 - Propagates all unexpected errors to the calling process How should you complete the Transact-SQL statement? To answer, drag the appropriate Transact-SQP segments...

CORRECT TEXT You have a database that contains the following tables. You need to create a query that lists the lowest-performing salespersons based on the current year-to-date sales period. The query must meet the following requirements: - Return a column named Fullname that includes the salesperson FirstName, a space, and...

You create a table by running the following Transact-SQL statement: You are developing a report that displays customer information. The report must contain a grand total column. You need to write a query that returns the data for the report. Which Transact-SQL statement should you run?A . B . C...