Answer / Trilok.singh

A predicate is a logical expression used to filter or select rows from a database table. A seek predicate, specifically, is a type of predicate used by an index seek operation in MS SQL Server to find data quickly within an index.

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1 Answers  

---

what is the output for this query select * from employee where 1=1;

4 Answers  

---

When would you use sql joins?

1 Answers  

---

What is dbcc command in sql server?

1 Answers  

---

What is a virtual table in sql?

1 Answers  

---

Where is my database stored on the hard disk in ms sql server?

1 Answers  

---

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1 Answers  

---

What is normalization according to you and explain its different levels?

1 Answers  

---

What is constraints and its types?

1 Answers  

---

What are the differences between union, intersect, and minus operators?

1 Answers  

---

What is store procedure?

1 Answers  

---

What are the advantages of paper records?

1 Answers  

---