Answer / Sunita

To create a user-defined function (UDF) in SQL Server, follow these steps: 1. Create a new function using CREATE FUNCTION statement with the desired parameters and return type. 2. Define the logic for the UDF within the function body. 3. Save and close the function. To execute the UDF, call it as part of an SQL query.

Explain indexed views?

1 Answers  

---

Can you explain important index characteristics?

1 Answers  

---

plz send every query in sql server2000

1 Answers   Infosys,

---

Do you know what are various aggregate functions that are available?

1 Answers  

---

What does ss stand for sexually?

1 Answers  

---

How to create a user name in a database?

1 Answers  

---

Which is the latest version of sql server and when it is released?

1 Answers  

---

Give main differences between "Truncate" and "Delete".

1 Answers   HCL,

---

How to select top 5 coloumn from a table without using coloumn name

5 Answers  

---

Explain the use of containers in ssis?

1 Answers  

---

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

1 Answers  

---

Explain Trigger with an example?

2 Answers  

---