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 the difference between primary key and unique constraints?

0 Answers  

---

What is the process of normalising?

0 Answers  

---

What happens if strings are casted into wrong code pages in ms sql server?

0 Answers  

---

What is stored in the mssqlsystemresource database? : sql server database administration

0 Answers  

---

How to avoid cursors?

3 Answers   CarrizalSoft Technologies, HP,

---

---

Mention the command used to rename the database.

0 Answers  

---

What is the purpose of object explorer and its features? : sql server management studio

0 Answers  

---

How to concatenate two strings in SQL Server.

0 Answers   HCL,

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

What are the steps to process a single select statement?

0 Answers  

---

What is a livelock?

0 Answers  

---

What is the difference between mysql and mysqli?

0 Answers   HCL,

---