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 to use clusters?

0 Answers   Amdocs,

---

Explain about local stored procedure?

0 Answers  

---

what operator performs pattern matching?

2 Answers  

---

What is difference between restoration and recovery in SQLServer?

3 Answers   Microsoft,

---

What are the essential components of sql server service broker?

0 Answers  

---

what is a transaction? : Sql server database administration

0 Answers  

---

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?

0 Answers  

---

Tell me what are cursors and when they are useful?

0 Answers  

---

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 Answers  

---

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

0 Answers   HCL,

---

How to get number of days in a given year?

4 Answers   ADP,

---

What is meant by Active-Passive and Active-Active clustering setup?

0 Answers  

---