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 is for foreign key ??

4 Answers   CarrizalSoft Technologies, Sabic,

---

How to read data in a table with "select" statements?

0 Answers  

---

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

9 Answers   tdfc, vsworx,

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers  

---

what is hash table

3 Answers   ILFS, Teledata,

---

What are the different index configurations a table can have?

0 Answers  

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

0 Answers  

---

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

0 Answers  

---

Name the different type of indexes in sql?

0 Answers  

---

what is checksum in sql server.........???

0 Answers   TCS,

---

What does null mean?

0 Answers  

---

What is an example of a foreign key?

0 Answers  

---