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
What encryption security is available in sql azure?
In which format does an image save in SQL Server database ?
How to create dbo table in sql server?
What is the contrast amongst drop and truncate?
What is the beast way to write CTE in SQL Server ?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Where in ms sql server is ’100’ equal to ‘0’?
What are sql azure firewall rules?
What is the filtered index?
What is blocking and how would you troubleshoot it? : sql server database administration
How do you size a resultset?
What is a trigger and types of a trigger?
Explain concepts of analysis services?
How to create percentile function?
What is a virtual table in sql?