Answer / prasanthi

Check Constraint:

The CHECK constraint is used to limit the value range that
can be placed in a column.

not null constraint:

if we give not null constraint to any column it will not
accept null values.

Unique Conatraint:

Unique key is similar to primary key but it accepts one
null value.
For o column Setting Unique key+Not NULL we can make
Primary Key.

Answer / chaitu

These are contraints

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

0 Answers  

---

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

0 Answers  

---

What is the difference between DATETIME2 and DATETIME?

0 Answers   Infosys,

---

How do I find the port number for sql server?

0 Answers  

---

What objects does the fn_my_permissions function reports on? : sql server security

0 Answers  

---

---

How does stuff differ from the replace function?

0 Answers  

---

What is the new security features added in sql server 2016? : sql server security

0 Answers  

---

Explain what is “asynchronous” communication in sql server service broker?

0 Answers  

---

Do comments need to go in a special place in sql server 2005?

0 Answers  

---

What are the types of indexes?

0 Answers  

---

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

0 Answers  

---

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

1 Answers  

---