« previous next »

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

Inotropic therapy does not have a role in the treatment of most heart failure patients. These drugs can make patients feel and function better but usually do not lengthen the predicted length of their lives.

Did you know?

Glaucoma is a leading cause of blindness. As of yet, there is no cure. Everyone is at risk, and there may be no warning signs. It is six to eight times more common in African Americans than in whites. The best and most effective way to detect glaucoma is to receive a dilated eye examination.

Did you know?

Asthma-like symptoms were first recorded about 3,500 years ago in Egypt. The first manuscript specifically written about asthma was in the year 1190, describing a condition characterized by sudden breathlessness. The treatments listed in this manuscript include chicken soup, herbs, and sexual abstinence.

Did you know?

Elderly adults are at greatest risk of stroke and myocardial infarction and have the most to gain from prophylaxis. Patients ages 60 to 80 years with blood pressures above 160/90 mm Hg should benefit from antihypertensive treatment.

Did you know?

Astigmatism is the most common vision problem. It may accompany nearsightedness or farsightedness. It is usually caused by an irregularly shaped cornea, but sometimes it is the result of an irregularly shaped lens. Either type can be corrected by eyeglasses, contact lenses, or refractive surgery.

The pattern of primary succession at Glacier Bay, Alaska. The pattern of primary succession at Glacier Bay, Alaska.
Primary visual processing areas (blue) in (a) human (lateral and mesial views) and (b) chimpanzee. Primary visual processing areas (blue) in (a) human (lateral and mesial views) and (b) chimpanzee.
One Module of the Primary Visual Cortex One Module of the Primary Visual Cortex
The world has been horrified recently at a U.S. Congress so polarized and paralyzed that it cannot p The world has been horrified recently at a U.S. Congress so polarized and paralyzed that it cannot p
Work Settings for People Earning Master’s and Bachelor’s Degrees in Psychology Work Settings for People Earning Master’s and Bachelor’s Degrees in Psychology
Fields of Environmental Science Fields of Environmental Science
Video: Introduction to Autism

For a complete list of videos, visit our video library