difference between function and procedure
Answer Posted / ramya gurrala
Functions:1)Do calculations mostly.
2)Must return value.
3)Calling methods.
4)Function can stand alone.
Procedure:1)Do actions mostly.
2)May or may not return value(the return method is not same as function method).
3)Calling methods.
4)Procedure can not stand alone.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the library index called?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
Is foreign key unique?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
What is enhanced database mirroring in sql server 2008?
If user is owning any SQL Objects, can we drop that user
What is user defined datatypes and when you should go for them?
What are the diifferences between the ms sql server vs mysql?
What to perform pattern match with the like operator?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
Can I run multiple instances of sql server 2000 at the same time on one computer?
What is dbcc? Give few examples.
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
What action plan is preferred if sql server is not responding?
Explain what are the basic functions for master, msdb, model, tempdb databases?