Answer / Jay Kumar Gaur

The two types of classifications of constraints in SQL Server are check constraints and database constraints. Check constraints are defined on individual columns or table-level rules that check the validity of data being inserted or updated, while database constraints include primary key, foreign key, unique, and default constraints.

How to assign null values to variables or columns?

1 Answers  

---

What does it mean to invest in the index?

1 Answers  

---

Explain the database you used in your final year project?

1 Answers   Wipro,

---

what is dbcc? : Sql server database administration

1 Answers  

---

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

3 Answers   iFlex,

---

What is openrowset sql server?

1 Answers  

---

what is hash nonclustered index

1 Answers  

---

Find columns used in stored procedure?

1 Answers  

---

Which is the latest version of sql server and when it is released?

1 Answers  

---

How is sql server used?

1 Answers  

---

How to write character string constants or literals in ms sql server?

1 Answers  

---

What is Extended user-defined?

1 Answers  

---