Answer / subbu

There are three types :
Scalar
In-line and
Multi-statement functions

Scalar UDFs return a single value. They are similar to
built-in functions such as DB_NAME(), GETDATE(), or USER_ID
(), which return a single string, date, or integer

In-line UDFs return a single row or multiple rows and can
contain a single SELECT statement. Because in-line UDFs are
limited to a single SELECT, they can't contain much logic

multi-statement UDFs can contain any number of statements
that populate the table variable to be returned. Notice
that although you can use INSERT, UPDATE, and DELETE
statements against the table variable being returned, a
function cannot modify data in permanent tables

What are the type of Indexes? which one is best, why?

6 Answers  

---

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

0 Answers  

---

Why use “pivot” in sql server?

0 Answers  

---

What are different types of raid levels?

0 Answers  

---

What is data modeling and Reterminal integrity?

0 Answers  

---

How to delete duplicate rows?

0 Answers  

---

OPTIMIZATION OF SP,CURSOR,TRIGGERS

0 Answers  

---

One table how may column and Primary key

3 Answers  

---

What is difference between line feed ( ) and carriage return ( )?

0 Answers  

---

What is service broker?

0 Answers  

---

Is INSTEAD OF trigger directly applicable to Table ?

0 Answers  

---

What is sql or structured query language?

0 Answers  

---