Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / srinivas k
Function should always return a value, where as Store Proc
may or may not return values.
Functions can be part of DML statements, where SP cannot be.
SP are precompiled and functions are not.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How many types of keys are there?
How to receive output values from stored procedures?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
Explain what are page splits? : SQL Server Architecture
Explain the different types of backups available in sql server? : sql server database administration
Write query to return all rows sql?
What is hot add cpu in sql server 2008?
role of sql sever 2005 in database rather than any other database
Tell me what is the difference between locking and multi-versioning?
Explain an automatic checkpoint
why would you use sql agent? : Sql server database administration
What is executereader?
Do you know the isolation level that sql server support?
please differentiate between delete and truncate?
between cast and convert which function would you prefer and why?
