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

Define master database?

0 Answers  

---

explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,

---

What is awe?

0 Answers  

---

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 Answers  

---

What do you mean by normalisation?

0 Answers  

---

Do you know what are different types of replication in sql server?

0 Answers  

---

can a database be shrunk with users active? : Sql server administration

0 Answers  

---

How to create a simple table to test triggers in ms sql server?

0 Answers  

---

What happens when unicode strings concatenate with non-unicode strings?

0 Answers  

---

How cand Optimize SQL Server Stored Procedures

1 Answers  

---

what is the cursor life span?

5 Answers   Evalueserve, HG,

---

Is SET a SQL Keyword?

4 Answers   BitWise,

---