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 we use ConnectorJ JDBC Driver with MS SQL?

0 Answers   PUCIT,

---

What do you understand by the denormalisation?

0 Answers  

---

What about UPDATESTATISTICS ?

2 Answers   HCL, Intelligroup,

---

which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM

5 Answers   Wipro,

---

Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,

---

How to count duplicated values in a column in ms sql server?

0 Answers  

---

How does normalization work?

0 Answers  

---

What is coalesce in sql server?

0 Answers  

---

What will happen when a Rollback statement is executed inside a trigger?

1 Answers   Flextronics, Hexaware,

---

What action plan is preferred if sql server is not responding?

0 Answers  

---

Can you explain powershell included in sql server 2008?

0 Answers  

---

What is filestream?

0 Answers  

---