Answer / Hrishikesh Kumar

A Not Null Constraint in SQL Server ensures that a column cannot accept NULL values. It enforces data integrity by preventing the insertion or updating of NULL values into a specified column.

What is cursor ? And what is difference between Trigger ?

3 Answers   HCL, Polaris,

---

i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers  

---

Tell me about the approaches which you used to counter the DI problems.

1 Answers   EXL,

---

Get Current System Date Time

2 Answers  

---

What is a covered index?

1 Answers  

---

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1 Answers  

---

What is the maximum size of a dimension? : sql server analysis services, ssas

1 Answers  

---

What are examples of triggers?

1 Answers  

---

What is data block and how to define data block size?

1 Answers  

---

What is a livelock?

1 Answers  

---

What are the different type of replication in sql server?

1 Answers  

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

1 Answers  

---