Answer / Neha Sona

A user-defined inline table-valued function (TVF) in SQL Server is a scalar-valued function that returns a table as a result. Unlike multi-statement table-valued functions, an inline TVF contains only one SELECT statement and it's executed every time the function is called, which makes them more efficient. They can be used wherever a table expression (table source) is allowed.

mention different types of relationships in the dbms?

1 Answers  

---

what is performance tunning in sql server ? explain.

1 Answers   Thomson Reuters,

---

What happens if the update subquery returns multiple rows in ms sql server?

1 Answers  

---

How can you list all the table constraints in a database?

1 Answers  

---

Explain cdc and sql injection?

1 Answers  

---

What is a DBMS, query, SQL?

1 Answers   Maveric,

---

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1 Answers  

---

How to stop log file growing too big?

1 Answers  

---

How to test odbc dsn connection settings?

1 Answers  

---

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1 Answers   Crown Solutions,

---

Where can you find the error log information? : sql server database administration

1 Answers  

---

What is tablesample?

1 Answers  

---