« previous next »

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

Most childhood vaccines are 90–99% effective in preventing disease. Side effects are rarely serious.

Did you know?

As many as 28% of hospitalized patients requiring mechanical ventilators to help them breathe (for more than 48 hours) will develop ventilator-associated pneumonia. Current therapy involves intravenous antibiotics, but new antibiotics that can be inhaled (and more directly treat the infection) are being developed.

Did you know?

More than 2,500 barbiturates have been synthesized. At the height of their popularity, about 50 were marketed for human use.

Did you know?

The familiar sounds of your heart are made by the heart's valves as they open and close.

Did you know?

In 1835 it was discovered that a disease of silkworms known as muscardine could be transferred from one silkworm to another, and was caused by a fungus.

Optical microscopes are commonly configured for bright-field (transmitted), phas Optical microscopes are commonly configured for bright-field (transmitted), phas
Radioactive protection services record book and two badge-style dosimeters. Radioactive protection services record book and two badge-style dosimeters.
Which row identifies correctly the excitatory and inhibitory neurons? Select one: Which row identifies correctly the excitatory and inhibitory neurons? Select one:
Math work Math work
Primary Active Transport Primary Active Transport
Guidelines for Field Triage of Injured Patients, Centers for Disease Control, 2011 Guidelines for Field Triage of Injured Patients, Centers for Disease Control, 2011
Video: Helper T cell receptors, activation, proliferation, differentiation & action

For a complete list of videos, visit our video library