Interested to Buy Any Domain ? << Click Here >> for more details...
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 the difference between a stored procedure and a user defined function?
Is it possible to create trigger on views?
What do you understand by SQL*Net?
What is sql service broker?
What is RAID? What are the different types of RAID configurations?
Explain difference between control flow and data flow?
How do you check sql server is up and running?
How to drop an existing schema in ms sql server?
What are partitioned views?
Explain the difference between function and stored procedure?
What is the difference between varchar and varchar types?
What command must you use to include the not null constraint after a table has already been created?
What is indexed view? How to create it?
How to set a database state to offline in ms sql server?
How would you add a section to a table?
