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 is foreign key related to primary key?

0 Answers  

---

How to enter date and time literals in ms sql server?

0 Answers  

---

What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

9 Answers   DELL, i Tech, Infosys, Siemens, TCS,

---

What is a performance monitor?

0 Answers  

---

can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 Answers  

---

What is the purpose of linked server configuration in sql server?

0 Answers  

---

How do you check sql server is up and running?

0 Answers  

---

What do you understand by a view? What does the with check option clause for a view do?

0 Answers  

---

Can some one please help with a query which will take only max value of a column in a join.

2 Answers  

---

What is the purpose of forms?

0 Answers  

---

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

0 Answers  

---

When to use Inner join & when to use subquery?

0 Answers   IBM,

---