difference between function and procedure
Answer Posted / ramya
1.a function must returns a value where as procedure may not return value
2.a procedure can have parameters of both i/p and o/p but
fun has only i/p parameters
3.in procedure we can perform all the dml operations but in function only select operation should be performed
4.we call a procedure by using 'exec' or 'execute' command where as function is called by using 'select' command
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the datatype of rowid?
How to how to convert numeric expression data types using the convert() function??
What are the advantages of using third-party tools?
What are indexes in sql?
How to generate create table script on an existing table in ms sql server?
What is temporal data type?
How to convert numeric expression data types using the cast() function?
Differentiate sql server reporting services vs. Crystal reports?
What does truncate do?
Explain what is analysis service repository?
Explain what is scheduled job and how to create it?
Can we shrink data file in sql server?
Can foreign key be deleted?
What is table level trigger?
What are the default system databases in sql server 2000?