« previous next »

Author Question: The primary work key is a field or fields whose value uniquely identifies a record. Indicate ... (Read 57 times)

saraeharris

  • Hero Member
  • *****
  • Posts: 546
on: Jul 7, 2018
The primary work key is a field or fields whose value uniquely identifies a record.
 
  Indicate whether the statement is true or false

Question 2

Explain how to work around the SQL Server IDENTITY constraint when non-sequential data must be entered.
 
  What will be an ideal response?


lin77x

  • Sr. Member
  • ****
  • Posts: 326
Reply #1 on: Jul 7, 2018
Answer to Question 1

FALSE

Answer to Question 2

The Transact-SQL IDENTITY_INSERT property allows users to control whether or not the IDENTITY constraint is in effect. To insert non-sequential data, we (1 ) use the command SET IDENTITY_INSERT tableName OFF to disable the IDENTITY constraint, (2 ) insert the non-sequential data, and (3 ) use the command SET IDENTITY_INSERT TableName ON to enable the IDENTITY constraint again.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

The first successful kidney transplant was performed in 1954 and occurred in Boston. A kidney from an identical twin was transplanted into his dying brother's body and was not rejected because it did not appear foreign to his body.

Did you know?

In 1886, William Bates reported on the discovery of a substance produced by the adrenal gland that turned out to be epinephrine (adrenaline). In 1904, this drug was first artificially synthesized by Friedrich Stolz.

Did you know?

Allergies play a major part in the health of children. The most prevalent childhood allergies are milk, egg, soy, wheat, peanuts, tree nuts, and seafood.

Did you know?

Hip fractures are the most serious consequences of osteoporosis. The incidence of hip fractures increases with each decade among patients in their 60s to patients in their 90s for both women and men of all populations. Men and women older than 80 years of age show the highest incidence of hip fractures.

Did you know?

In Eastern Europe and Russia, interferon is administered intranasally in varied doses for the common cold and influenza. It is claimed that this treatment can lower the risk of infection by as much as 60–70%.

Primary glands of the endocrine system. Primary glands of the endocrine system.
Glaucoma. (a) A buildup of pressure within the eye cavities, often caused by a blockage of vessels t Glaucoma. (a) A buildup of pressure within the eye cavities, often caused by a blockage of vessels t
Preparation of sterile field 2 Preparation of sterile field 2
As some groups do ethnic work, they produce a mythical long-lost heritage, as in this photo of ... As some groups do ethnic work, they produce a mythical long-lost heritage, as in this photo of ...
Typical Work Settings for Massage Therapists Typical Work Settings for Massage Therapists
Opener A field of pumpkins, where size is under the influence of additive alleles Opener A field of pumpkins, where size is under the influence of additive alleles
Video: Retina

For a complete list of videos, visit our video library