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

how we use window authentication connection with sql server.?

0 Answers   MCN Solutions,

---

What is cdc in sql server?

0 Answers  

---

What is table join?

0 Answers  

---

Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,

---

What are triggers? How do you invoke a trigger on demand?

0 Answers   Hexaware,

---

---

List all types of constraints in sql server?

0 Answers  

---

How can you check the level of fragmentation on a table?

0 Answers  

---

What is ms sql server index?

0 Answers  

---

What is difference between count (*) and count column?

0 Answers  

---

What is an execution plan? How would you view the execution plan?

0 Answers  

---

what is the maximum size of a row in sql server 2000 and 2005

2 Answers  

---

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,

---