• Register
0 votes


Can anyone guide me with the right solution?

If you define a column with a default value, that value is used whenever a row?

a. with a zero value for that column is added to the table
b. is added to the table
c. in the table is updated
d. that doesn't include a value for that column is added to the table

7 5 3
5,380 points

1 Answer

0 votes


Let me try to help you with your query.

The correct answer is: that doesn't include a value for that column is added to the table
Hope this might help you.

7 4 2
10,530 points

Related questions

0 votes
1 answer 15 views
Problem : I want to do below query INSERT INTO dbo.tbl_A_archive  SELECT * FROM SERVERxyz.DB.dbo.tbl_A However even after I ran below code set identity_insert dbo.tbl_A_archive on I am facing below error message “Can only be specified when a column list is used and IDENTITY_INSERT ... a huge number of columns. I can not type all of the columns out manually. How can I get this to be fixed?
asked Jan 29 jwilliam 3.9k points
0 votes
2 answers 44 views
Problem: I am new, I need help, can anyone help me by filling in the blanks? ________ is used to ensure that data is organized most efficiently in a database?
asked Feb 19 maddi86 5.4k points
0 votes
1 answer 255 views
Problem : I am facing following error while executing script cannot insert explicit value for identity column in table when identity_insert is set to off.
asked Nov 15, 2019 peterlaw 6.9k points
0 votes
1 answer 19 views
Problem: I am able to create the table named employee which contains the column empid which is a computed column and empid column is the primary key also. It is the self referencing table and the column managerid references back to itself. But now if I try to save ... error my table is still working perfectly. I am trying to work in a table graphically not coding every time I make the change.
asked Jul 4 Raphael Pacheco 4.9k points