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 are the different types of Indexes available in SQL Server?

0 Answers  

---

In which situation you use Self joins?

1 Answers   CarrizalSoft Technologies, HP, TCS,

---

What are different types of views?

0 Answers  

---

What is merge join?

0 Answers  

---

What do you mean by sql server agent?

0 Answers  

---

Where is my database stored on the hard disk in ms sql server?

0 Answers  

---

Difference between drill down and drill through report.

0 Answers  

---

What is the default sql server instance name?

0 Answers  

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  

---

What is openxml in sql server?

0 Answers  

---

Explain stored procedure?

0 Answers  

---