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

What is Extended user-defined?

0 Answers  

---

Explain timestamp datatype?

0 Answers  

---

how do u do Performance tunning ?

1 Answers   Infodat Technologies, Satyam,

---

what are user defined datatypes and when you should go for them? : Sql server database administration

0 Answers  

---

what is database replicaion? : Sql server database administration

0 Answers  

---

Define msdb database?

0 Answers  

---

How can I create a plain-text flat file from SQL Server as input to another application?

2 Answers  

---

What is a Lock and let me know Different types of locks?

2 Answers  

---

What do u mean by orphan users, how will u list them in the DB

2 Answers   IBM,

---

What is @@Identity in sql?

1 Answers   Cap Gemini,

---

What command would you use to add a column to a table in sql server?

0 Answers  

---

What is the filtered index?

0 Answers  

---