Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / jijo
Three types
1) Scalar
A scalar user defined function returns one of the scalar
data type .text,ntext,etc
2) inline table Value
An inline table value function return a table data type
3) multi -statement table value function
A multi -statement table value function return a table and
is also an exceptional alternative to a view as the function
can support multiple t-sql statements to build the final result
| Is This Answer Correct ? | 26 Yes | 4 No |
Post New Answer View All Answers
How to convert numeric values to integers in ms sql server?
How can we improve performance by using SQL Server profiler?
What is the significance of null value and why should we avoid permitting null values?
How to get a list of columns in a view using the "sp_columns" stored procedure?
What is merge statement?
Can a cursor be updated? If yes, how you can protect which columns are updated?
When does a workload on SQL Azure get throttled?
Difference between connected and disconnected database in .net with sql server?
Why should we go for stored procedures? Why not direct queries?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
Explain triggers?
Explain following error properties?
Can we use custom code in ssrs?
Working with TLogs
What do you understand by triggers?
