70-315 Developing and Implementing Web Applications with Microsoft Visual C# .NET Prep Tutorial

Microsoft ™

70-315 Developing and Implementing Web Applications with Microsoft Visual C# .NET

Note 1: 70-315 Exhibit and all related diagrams are not shown in demo questions.
Note 2: 70-315 Answers are not shown in demo questions.
Exhibits and Answers are only provided in the Full Version.

Demo Question 15.

Your ASP.NET application manages order entry data by using a DataSet object named CKorderEntry. You are creating a Transact-SQL statement that will return the value of an Identity column in the OrderEntry table. Which T-SQL function should you use in your query to determine the value of the Identity column? (Select the best choice.)

A. IDENT_SEED
B. DATALENGTH
C. IDENT_INCR
D. SCOPE_IDENTITY

Display Answer

Purchase Full Version:

70-315 Printable PDF Prep Guide $49.95 BUY NOW!

70-315 Test Simulation Engine $69.95 BUY NOW!

70-315 PDF & Test Simulation Engine $99.95 BUY NOW!

Answer: D The T-SQL function that you should use in your query to determine the value of the Identity column is SCOPE_IDENTITY. The SCOPE_IDENTITY function returns the value of the Identity column of the row that was most recently added to a table. Identity columns are columns that contain a unique number and are used to uniquely identify each row. By using this value as an output parameter in an INSERT stored procedure, it is possible to automatically update datasets with the value of Identity or Autonumber columns in scenarios where multiple users will be inserting rows into the same table.

Explanation: