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

When is the use of update_statistics command?

0 Answers  

---

Where are SQL server users names and passwords are stored in sql server?

0 Answers   HCL,

---

What are 3 ways to get a count of the number of records in a table?

0 Answers  

---

How to create a testing table with test data in ms sql server?

0 Answers  

---

How to defragment indexes with alter index ... Reorganize?

0 Answers  

---

---

Define DML and DCL statements?

1 Answers   Hexaware, NIIT,

---

What is use of except clause? How it differs from not in clause?

0 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

what is database replication? : Sql server database administration

0 Answers  

---

How to include text values in sql statements?

0 Answers  

---

Explain different types of Normalization.

1 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

what is the difference between openrowset and openquery?

0 Answers  

---