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
How to update muliple row in single query?
How to change the ownership of a schema in ms sql server?
Can we use custom code in ssrs?
What is the difference between insensitive and scroll cursor?
How to find index size for each index on table?
How to receive output values from stored procedures?
How do we know if any query is retrieving a large amount of data or very little data?
What is the difference between locking and multi-versioning?
What is the use of for clause?
What is an indexed view?
What is user defined stored procedures?
What is a periodical index?
What is sql server used for?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
Do you know sql server 2008 introduces automatic auditing?