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 requirements on sql server network connections?

0 Answers  

---

How to rebuild all indexes on a single table?

0 Answers  

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

---

How to insert multiple rows with a subquery?

0 Answers  

---

Explain left outer join and right outer join?

0 Answers  

---

Can we use pragma autonomous_transaction in trigger?

0 Answers  

---

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

What command is used to delete a table from the database in the sql server and how?

0 Answers  

---

What is optimistic concurrency?

0 Answers  

---

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.

6 Answers   IBM,

---

Can you explain the types of Joins that we can have with Sql Server?

2 Answers  

---

HOW TO RENAME A COLUMN NAME

3 Answers  

---