« previous next »

Author Question: The primary work key is a field or fields whose value uniquely identifies a record. Indicate ... (Read 95 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?

Though Candida and Aspergillus species are the most common fungal pathogens causing invasive fungal disease in the immunocompromised, infections due to previously uncommon hyaline and dematiaceous filamentous fungi are occurring more often today. Rare fungal infections, once accurately diagnosed, may require surgical debridement, immunotherapy, and newer antifungals used singly or in combination with older antifungals, on a case-by-case basis.

Did you know?

There are 60,000 miles of blood vessels in every adult human.

Did you know?

After 5 years of being diagnosed with rheumatoid arthritis, one every three patients will no longer be able to work.

Did you know?

More than nineteen million Americans carry the factor V gene that causes blood clots, pulmonary embolism, and heart disease.

Did you know?

In the United States, an estimated 50 million unnecessary antibiotics are prescribed for viral respiratory infections.

Estimated terrestrial net primary productivity across Canada. Estimated terrestrial net primary productivity across Canada.
Primary cilium and the Hedgehog pathway Primary cilium and the Hedgehog pathway
Forms of primary adult glaucoma: (a) in chronic open-angle glaucoma, the anterior chamber angle rema Forms of primary adult glaucoma: (a) in chronic open-angle glaucoma, the anterior chamber angle rema
Equipment Inventory Record Equipment Inventory Record
How did muscle work around eyeball? How did muscle work around eyeball?
Primary growth in a root Primary growth in a root
Video: Ciliate conjugation Animation

For a complete list of videos, visit our video library