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 raid and what are different types of raid configurations?

0 Answers  

---

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,

---

When you use @@error and try-catch?

0 Answers  

---

Can you explain what is indexed view? How to create it?

0 Answers  

---

How is table type constraint applied to a table?

0 Answers  

---

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

---

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

0 Answers  

---

Why are you getting errors when creating a new odbc dsn?

0 Answers  

---

Mention a few common trace flags used with sql server?

0 Answers  

---

How can you know if the row fetched from cursor is still valid in underlying table?

0 Answers  

---

What the different topologies in which replication can be configured?

0 Answers  

---

What are the five major components of a dbms?

0 Answers  

---