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 is measure group, measure? : sql server analysis services, ssas
Explain foreign key in sql server?
How to insert new line characters into strings?
What is table constraint?
What is the dbcc command and why is it used?
What is the difference between for auto and for nested?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
Why use “in” clause in sql server?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
What is tablix?
What is a join in sql?
What is not null constraint?
What is dbcc command in sql server?
What is snapshot report?
What are the restrictions applicable while creating views? : SQL Server Architecture