Answer Posted / vikas kant
User Define Functions are used to define its own T-Sql
Function which can have 0 or more input parameters and
returns a single scalar data value type or table data type.
we have three type of UDF:-
1.Scalar user defined function
2.Inline table valued Function
3.Multiple table valued function
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Can group by and orderby be used together?
Can we use pragma autonomous_transaction in trigger?
What is fill factor and pad index?
How to run queries with sql server management studio express?
What are the steps you can take to avoid “deadlocks”?
Can you create a logon trigger in sql server 2005 express edition?
Mention the differences between local and global temporary tables.
What is sql service broker?
Define tool Manage Statistics in SQL Server 2000 query ?
What are examples of triggers?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
User wants only to display only pdf as export option in report manager. How to achieve this?
What are the tool windows in sql server management studio? : sql server management studio
Differentiate between a local and a global temporary table?
What are the different normalization forms?