« previous next »

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

Less than one of every three adults with high LDL cholesterol has the condition under control. Only 48.1% with the condition are being treated for it.

Did you know?

The first war in which wide-scale use of anesthetics occurred was the Civil War, and 80% of all wounds were in the extremities.

Did you know?

Hyperthyroidism leads to an increased rate of metabolism and affects about 1% of women but only 0.1% of men. For most people, this increased metabolic rate causes the thyroid gland to become enlarged (known as a goiter).

Did you know?

Approximately one in four people diagnosed with diabetes will develop foot problems. Of these, about one-third will require lower extremity amputation.

Did you know?

Since 1988, the CDC has reported a 99% reduction in bacterial meningitis caused by Haemophilus influenzae, due to the introduction of the vaccine against it.

Structure of cellulose, the main macromolecule of the primary cell wall Structure of cellulose, the main macromolecule of the primary cell wall
Olenoides erratus from the Mt. Stephen Trilobite Beds (Middle Cambrian) near Field, British Columbia Olenoides erratus from the Mt. Stephen Trilobite Beds (Middle Cambrian) near Field, British Columbia
Damage to Field CA1 Caused by Anoxia Damage to Field CA1 Caused by Anoxia
Primary Groups: Families Primary Groups: Families
How do men who work in traditionally feminine nurturng jobs and women who work in jobs that give ... How do men who work in traditionally feminine nurturng jobs and women who work in jobs that give ...
What is the maximum velocity (in km/s) of a photoelectron emitted from a surface whose work ... What is the maximum velocity (in km/s) of a photoelectron emitted from a surface whose work ...
Video: Mechanisms of capillary exchange (transcytosis & bulk flow)

For a complete list of videos, visit our video library