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

Can we create clustered index on non primary key column

20 Answers   ABC, CTS,

---

How can we rewrite sub-queries into simple select statements or with joins?

0 Answers  

---

what is Full Text Search ?

1 Answers   TCS,

---

Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  

---

What is bit datatype and what's the information that can be stored inside a bit column?

1 Answers  

---

What is difference between after and before?

0 Answers  

---

What is subquery? Explain the properties of a subquery?

0 Answers  

---

What are functions in the sql server?

0 Answers  

---

How do I create an extended event in sql server?

0 Answers  

---

What is the difference between stored procedure and user defined functions?

0 Answers  

---

What are the differences between char and nchar in ms sql server?

0 Answers  

---

how to copy only distinct data into another table which is not already exist in database?

2 Answers   Spectra,

---