Explain the benefits of User-Defined Functions?
Submitted by: Administratora. Can be used in a number of places without restrictions as compared to stored procedures.
b. Code can be made less complex and easier to write.
c. Parameters can be passed to the function.
d. They can be used to create joins and also be sued in a select, where or case statement.
e. Simpler to invoke.
Submitted by: Administrator
b. Code can be made less complex and easier to write.
c. Parameters can be passed to the function.
d. They can be used to create joins and also be sued in a select, where or case statement.
e. Simpler to invoke.
Submitted by: Administrator
Read Online SQL Server Functions Job Interview Questions And Answers
Top SQL Server Functions Questions
| ☺ | Explain Steps of normalization? |
| ☺ | What is De-normalization? |
| ☺ | Explain how DTS is used to extract, transform and consolidate data? |
| ☺ | Do you know exporting and importing utility? |
| ☺ | What are scalar functions? |
Top New MS SQL Server Categories
| ☺ | SQL Server Database Administrator Interview Questions. |
| ☺ | SQL Server Service Broker Interview Questions. |
| ☺ | SQL Server Locks Interview Questions. |
| ☺ | SQL Server Constraints Interview Questions. |
| ☺ | MS SQL Data Mining Interview Questions. |
