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 happens if null values are involved in bitwise operations?

0 Answers  

---

How can you swap values between two rows in a table using single- SQL statement?

1 Answers   Tavant Technologies, Virtusa,

---

Name few of the dcl commands in sql?

0 Answers  

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

---

What is the fastest way to permanently delete a 1 million row table named customers?

0 Answers  

---

how to implement locking in sql server

3 Answers   Satyam,

---

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

0 Answers  

---

What is indexed views? plz explain with example?

2 Answers  

---

what is mean by crystal repoart? ahere we will mainly use that?

1 Answers  

---

How do I port a number to sql server?

0 Answers  

---

How you can add messages to the nt event log from within a stored procedure?

0 Answers  

---

How we Resize table,temp table, database and log file size in SQL Server 2005

1 Answers   ABC,

---