SQL Server Interview Questions

Submit Interview Question with Answer | Search Questions | Interview Home | Exclusive Interview Home |

What is user-defined functions in SQL Server?

Answer:
User-Defined Functions allows to define custom T-SQL functions that can accept zero or more parameters and return a single scalar data value or a table data type.

In terms of functionality it is similar to C# or VB.NET functions except the fact that code is written in T-SQL :)

For more visit http://www.sqlteam.com/article/user-defined-functions

Thanks

Found interesting? Add this to:

| More

Write Response

Navigate to: Submit Interview Questions Next Question >>: What is user-defined data type in SQL Server? ... << Previous Question: What is the use of Keyword WITH ENCRYPTION keyword in SQL Server? ... Random Questions: Random Interview Questions Help: If for some reason you are getting the same question by clicking Next Question or Previous Question, Try clicking Categories link above.

Related interview questions
What is user-defined data type in SQL Server? ... What is the use of bit data type and what kind of data is stored into it? ... What is blocking in SQL Server? ... How to write a method in a class and build as .dll ... How to declare a method in an Interface? ... How to add auto increment column in the DataTable? ... How to create a column in the DataTable? ... How to add a new row in DataTable? ... What is the difference WCF and Web services? ... What are various ways of hosting WCF Services? ... What are the main components of WCF? ... What was the code name for WCF? ... More ...

General Notice: If you found plagiarised (copied) contents on this page, please let us know the original source along with your correct email id (to communicate) for further action.

Copyright © DotNetFunda.Com. All Rights Reserved. Copying or mimicking the site design and layout is prohibited. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks. | 9/3/2010 4:08:48 AM

SQL Server Interview Questions

What is user-defined functions in SQL Server?

Related interview questions