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 a Stored Procedure?

8 Answers  

---

Can a table have 2 primary keys?

0 Answers  

---

How do I find the sql server instance name?

0 Answers  

---

how can i lock the column in the table

2 Answers   Accenture,

---

How to encrypt data between dialogs?

0 Answers  

---

---

Explain active/passive and active/active cluster configurations?

0 Answers  

---

Tell me extended events in sql server 2008?

0 Answers  

---

What is normalization? Describe its different types.

0 Answers   Wipro,

---

Explain system rowset functions?

0 Answers  

---

Can we write a distributed query and get some data which is located on other server and oracle database?

0 Answers  

---

How can we improve performance by using SQL Server profiler?

0 Answers   QuestPond,

---

1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?

7 Answers   Microsoft,

---