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

how many type of subquery?

2 Answers  

---

How optimize sql query with multiple joins in sql server?

0 Answers  

---

What number aggregate functions are accessible there in sql?

0 Answers  

---

What is the use of @@spid?

0 Answers  

---

Is trigger fired implicitely?

2 Answers  

---

---

What is a sub-query? When would you use one?

3 Answers  

---

What is failover clustering overview?

0 Answers  

---

Explain few of the new features of sql server 2008 management studio

0 Answers  

---

Can you type more than one query in the query editor screen at the same time?

0 Answers  

---

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

0 Answers  

---

How extra digits are handled with numeric data type literals?

0 Answers  

---

What is a partitioned view?

0 Answers  

---