Difference between Function and Procedure-in general?
Answer Posted / sudhindra
A Function is always returns a value using the return
statement. A Procedure may return one or more values
through parameters or may not return at all.
Is This Answer Correct ? | 28 Yes | 6 No |
Post New Answer View All Answers
Can we check locks in database? If so, how can we do this lock check?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
Describe different Processing Modes offered by SSRS?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is policy management?
How each E-R model constructs can be mapped to the relational model?
Does sql server use t sql?
How would you use user_constraints table in DB?
What is sql server profiler trace data file?
Why use view instead of a table?
Differentiate between SQL and ORACLE joins and write their syntax.
What is @@error in sql?
what is a live lock? : Sql server database administration
What does it mean to normalize a database and why would you do it?
What is the difference between stored procedure and user defined functions?