Difference between Function and Procedure-in general?
Answer Posted / mona
Function can return at most one value at a time while
procedure can return more than one value at a time You can
use function within Sql Statement and you cannot use stored
procedure with in Sql Statement
Is This Answer Correct ? | 19 Yes | 11 No |
Post New Answer View All Answers
Mention what are the different types of ssrs reports?
What are the database objects? : SQL Server Architecture
Will the writetext statement activate a trigger?
Why use sub query in sql server and list out types of sub queries?
Do you know what is difference between stored procedure and user defined function?
query processing
What is the command used to recompile the stored procedure at run time?
Explain sub-query?
How to return the date part only from a sql server datetime datatype?
Explain concepts of analysis services?
How to divide query output into multiple groups with the group by clause in ms sql server?
Do you know what is rank function?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
What are the different methods available under sqlcommand class to access the data?
Explain log shipping?