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 do we have to check in database testing?

0 Answers  

---

What is the difference between a local and a global variable?

5 Answers  

---

How use inner join in sql server?

0 Answers  

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

0 Answers  

---

What is data source object?

0 Answers  

---

Which joins are sql server default?

0 Answers  

---

What is stored in the mssqlsystemresource database? : sql server database administration

0 Answers  

---

Scalability, Availability, Integration with internet, etc.)?

0 Answers  

---

What is molap and its advantage? : sql server analysis services, ssas

0 Answers  

---

How to execute stored procedure and set temp table in sql server?

0 Answers  

---

What are the different types of backups avaialabe in sql server 2005?

0 Answers  

---

Why does sql studio use a single registered database repository? : sql server management studio

0 Answers  

---