« previous next »

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

It is believed that humans initially contracted crabs from gorillas about 3 million years ago from either sleeping in gorilla nests or eating the apes.

Did you know?

The longest a person has survived after a heart transplant is 24 years.

Did you know?

Multiple experimental evidences have confirmed that at the molecular level, cancer is caused by lesions in cellular DNA.

Did you know?

There are actually 60 minerals, 16 vitamins, 12 essential amino acids, and three essential fatty acids that your body needs every day.

Did you know?

Signs and symptoms that may signify an eye tumor include general blurred vision, bulging eye(s), double vision, a sensation of a foreign body in the eye(s), iris defects, limited ability to move the eyelid(s), limited ability to move the eye(s), pain or discomfort in or around the eyes or eyelids, red or pink eyes, white or cloud spots on the eye(s), colored spots on the eyelid(s), swelling around the eyes, swollen eyelid(s), and general vision loss.

An electrocardiogram (EKG) wave, a record of the electrical signal as it moves through the conductio An electrocardiogram (EKG) wave, a record of the electrical signal as it moves through the conductio
Gravity field of the Moon Gravity field of the Moon
To cleanse an open wound, begin close to the wound and work outward in full or half circles. To cleanse an open wound, begin close to the wound and work outward in full or half circles.
Reserves can work for both fish and fishers Reserves can work for both fish and fishers
What is the contribution of studying wing spot in the field? What is the contribution of studying wing spot in the field?
Survivorship curves. Blue lines are theoretical curves. Red dots are data from field studies. Survivorship curves. Blue lines are theoretical curves. Red dots are data from field studies.
Video: Regulation of GFR: three methods, autoregulation & autoregulation via myogenic mechanism

For a complete list of videos, visit our video library