Answer Posted / dinesh sharma
In Sql Server Function are Like S.P Mean Batch of SQL
command. But Function Must Return Single Value
In SQL Server Four Type Of Function
1)Table-Valued Function:Return Datatable
2)Scaler Valued Function:return Single value
3)Aggreated Funtion:Return Aggreatged Result set
4)System Funtion:used by system like Rowset etc.
| Is This Answer Correct ? | 8 Yes | 13 No |
Post New Answer View All Answers
List the ways in which dynamic sql can be executed?
Why do we use functions?
What xml support does the sql server extend?
What is logshipping and its purpose?
How to find out what is the default collation in a database?
How to connect to SQL Azure Database by using sqlcmd?
What are the types of subquery?
What is data modification?
What is Federation and Federation Member?
What is the order by used for?
What are the acid properties?
What is sql collation?
Difference between aggregate functions of sql?
How to create a user name in a database?
How to change the system date and time from SQL Plus Terminal ?
