What is difference between stored procedure and function?
Answer Posted / rakesh
mojor difference is
function must return a value but a
procedure may or may not return a value
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Find nth lowest salary or get nth lowest salary?
Should you normalize audio?
What do we have to check in database testing?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
What is the definition for sql server 2000?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
Describe in brief authentication modes in sql server.
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
what's the information that can be stored inside a bit column? : Sql server database administration
What are the tools available in market as an alternative to sql server reporting services?
How can you check the level of fragmentation on a table?
Do you know what guidelines should be followed to help minimize deadlocks?
Write query to return all rows sql?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
Does sql server use t sql?