70-761

You have a table named AuditTrail that tracks modifications to data in other tables. The AuditTrail table is updated by many processes. Data input into AuditTrail may contain improperly formatted date time values. You implement a process that retrieves data from the various columns in AuditTrail, but sometimes the process...

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...

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 a Cartesian product, combining...

You have a database that tracks orders and deliveries for customers in North America. The database contains the following tables: Application. Cities Sales. CustomerCategories The company's development team is designing a customer directory application. The application must list customers by the area code of their phone number. The area code...

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...

You have a database that tracks orders and deliveries for customers in North America. The database contains the following tables: Application. Cities Sales. CustomerCatagories The company's development team is designing a customer directory application. The application must list customers by the area code of their phone number. The area code...

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...

DRAG DROP You query a database that includes two tables: Project and Task. The Project table includes the following columns: When running an operation, you updated a column named EndTime for several records in the Project table, but updates to the corresponding task records in the Task table failed. You...

DRAG DROP You query a database that includes two tables: Project and Task. The Project table includes the following columns: When running an operation, you updated a column named EndTime for several records in the Project table, but updates to the corresponding task records in the Task table failed. You...

HOTSPOT You have the following stored procedure: You run the following Transact-SQL statements: What is the result of each Transact-SQL statement? To answer, select the appropriate options in the answer area. View AnswerAnswer: