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
Will sql server 2005 allow you to reduce the size of a column?
Which are the third-party tools used in sql server and why would you use them?
What is the template in sql?
What is the difference between a check constraint and a rule?
What is proper subset of candidate key?
Is sql server implemented as a service or an application? : Sql server database administration
How data can be copied from one table to another table?
What is sql server schema compare? How we can compare two database schemas?
How to test subquery results with the exists operator?
What are the differences between char and nchar in ms sql server?
What is use of except clause? How does it differ from not in clause?
How do I find the port number for sql server?
explain what is raid and what are different types of raid configurations? : Sql server database administration
How to count duplicated values in a column in ms sql server?
Why do we need different type of parameter?