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

Does hive support indexing?

0 Answers  

---

what operator performs pattern matching?

2 Answers  

---

Define msdb database?

0 Answers  

---

Does partitioning help performance?

0 Answers  

---

Explain transaction server implicit?

0 Answers  

---

how to select a field with firstletter as capital and remaining are small letters

11 Answers  

---

What is the difference between clustered and non-clustered indexes in ms sql server?

0 Answers  

---

what are acid properties? : Sql server database administration

0 Answers  

---

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

0 Answers  

---

What protocol does sql server use?

0 Answers  

---

what are batch in sql server?

2 Answers   Satyam,

---

What is the difference between count and distinct count?

0 Answers  

---