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 index can be created for single table

4 Answers   CarrizalSoft Technologies, Verizon,

---

What is the difference between 2-Tier architecture and 3-Tier architecture

15 Answers   CTS, MCN Solutions, Oracle,

---

What are the encryption mechanisms in sql server?

0 Answers  

---

What is transaction ? Give me one example.

11 Answers   Melstar, Wipro,

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

What are the approximate numeric data types?

0 Answers  

---

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

---

What is RAID? What are the different types of RAID configurations?

0 Answers   Flextronics,

---

How to get the definition of a trigger back?

0 Answers  

---

How to create user messages with print statements in ms sql server?

0 Answers  

---

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

0 Answers  

---

What is Primary key and foreign key? Give an example

4 Answers   TCS,

---