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 database replication? What are the different types of replication you can set up in sql server?

0 Answers  

---

How do you run a trace?

0 Answers  

---

How to delete multiple rows with one delete statement in ms sql server?

0 Answers  

---

How to enter unicode character string literals in ms sql server?

0 Answers  

---

What is the difference between a function and a stored procedure?

0 Answers  

---

How you provide security to cube? : sql server analysis services, ssas

0 Answers  

---

I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access

4 Answers  

---

Tell me about Triggers?

3 Answers   Cap Gemini,

---

Why functions are used in sql server?

0 Answers  

---

Does full backup break log chain?

0 Answers  

---

How to update values in a table with update statements in ms sql server?

0 Answers  

---

can we have a nested transaction? : Sql server database administration

0 Answers  

---