70-761

You create a table named Customer by running the following Transact-SQL statement: You must insert the following data into the Customer table: You need to ensure that both records are inserted or neither record is inserted. Solution: You run the following Transact-SQL statement: Does the solution meet the goal?A ....

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

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 named My Db. You run the following Transact-SQL statements: A value of 1 in the IsActive column indicates that a user is active. You need to create a count for active users in each role. If a role has no active users. You must display a...

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

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

DRAG DROP You are developing a database to track customer orders. The database contains the following tables: Sales.Customers, Sales.Orders, and Sales.OrderLines. The following table describes the columns in Sales.Customers. The following table describes the columns in Sales.Orders. The following table describes the columns in Sales.OrderLines. You need to create a...

You have a table named Products that contains information about the products that your company sells. The table contains many columns that do not always contain values. You need to implement an ANSI standard method to convert the NULL values in the query output to the phrase "Not Applicable". What...

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