« previous next »

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

Drugs are in development that may cure asthma and hay fever once and for all. They target leukotrienes, which are known to cause tightening of the air passages in the lungs and increase mucus productions in nasal passages.

Did you know?

The first monoclonal antibodies were made exclusively from mouse cells. Some are now fully human, which means they are likely to be safer and may be more effective than older monoclonal antibodies.

Did you know?

The liver is the only organ that has the ability to regenerate itself after certain types of damage. As much as 25% of the liver can be removed, and it will still regenerate back to its original shape and size. However, the liver cannot regenerate after severe damage caused by alcohol.

Did you know?

The ratio of hydrogen atoms to oxygen in water (H2O) is 2:1.

Did you know?

Essential fatty acids have been shown to be effective against ulcers, asthma, dental cavities, and skin disorders such as acne.

Annual net primary productivity on Earth. Annual net primary productivity on Earth.
Wound healing by primary intention. Wound healing by primary intention.
Focusing Jets by Magnetic Fields Focusing Jets by Magnetic Fields
Edmund Husserl (1859–1938). German philosopher who founded the field of phenomenology. In his ... Edmund Husserl (1859–1938). German philosopher who founded the field of phenomenology. In his ...
Harlem’s Promise Academy has a record of graduating and sending to college more than 90 percent ... Harlem’s Promise Academy has a record of graduating and sending to college more than 90 percent ...
A 60-kg skier starts from rest from the top of a 50-m high slope. If the work done by friction ... A 60-kg skier starts from rest from the top of a 50-m high slope. If the work done by friction ...
Video: Angiotensin II - kidneys, adrenal glands and dehydration

For a complete list of videos, visit our video library