70-305 Developing and Implementing Web Applications with Microsoft Visual Basic.NET Study Guides

Microsoft ™

70-305 Developing and Implementing Web Applications with Microsoft Visual Basic.NET

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

Demo Question 13.

You work as the Web developer at EliteCertify.com. You create a new ASP.NET application named EliteCertify App12. EliteCertify App12 is used to manage customer purchasing information for the company. EliteCertify App12 uses a DataSet object named purchasesEntry. You want to return the value of an Identity column in the purchasesEntry table. To do this, you create a Transact-SQL statement. Choose the Transact-SQL function you should use in your query to return the value of the Identity column.

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

Display Answer

Purchase Full Version:

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

70-305 Test Simulation Engine $69.95 BUY NOW!

70-305 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: