Answer / m.s.patil

Thre are mainly three types of functions in SQl server 2005.
1.) Scalar function
2.) Inline table valued function
3.) Multi statement table valued function

Answer / jijo

Three types

1) Scalar
A scalar user defined function returns one of the scalar
data type .text,ntext,etc

2) inline table Value
An inline table value function return a table data type

3) multi -statement table value function

A multi -statement table value function return a table and
is also an exceptional alternative to a view as the function
can support multiple t-sql statements to build the final result

How can you find out how many rows returned in a cursor?

0 Answers  

---

difference between Clustered index and non clustered index ?

0 Answers   Infosys,

---

Differentiate between a local and a global temporary table?

0 Answers  

---

Explain having clause?

0 Answers  

---

What does truncate do?

0 Answers  

---

---

How will you optimize a stored procedure optimization?

0 Answers  

---

Indexes are updated automatically is the full-text index also updated automatically?

0 Answers  

---

How can I know what locks are running on which resource?

0 Answers  

---

Your table has a large character field there are queries that use this field in their search clause what should you do?

0 Answers  

---

How can windows applications connect to sql servers via odbc?

0 Answers  

---

what is the difference between Delete and Truncate command in SQL

0 Answers   BirlaSoft,

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---