Answer / Ashutosh Kumar Pandey

In SQL Server, a domain constraint is a rule that you can use to restrict the values that users can enter into a column in a table. For example, the CONSTRAINT clause can be used to define a CHECK constraint, which checks whether an expression is true for each row before it is inserted or updated.

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

1 Answers  

---

What is local temp table?

1 Answers  

---

what's the maximum size of a row? : Sql server database administration

1 Answers  

---

what is hash nonclustered index

1 Answers  

---

Explain sp_configure commands, set commands?

3 Answers  

---

What are out-of-range errors with date and time literals?

1 Answers  

---

What is sorting and what is the difference between sorting and clustered indexes?

1 Answers  

---

what are database files and filegroups? : Sql server database administration

1 Answers  

---

Explain cross join or cartesian product in sql?

1 Answers  

---

Explain candidate key, alternate key, and composite key?

1 Answers  

---

What are the different types of upgrades that can be performed in sql server?

1 Answers  

---

What are cursors?

8 Answers  

---