what is the difference between procedure and function.
Answer Posted / saraswathi muthuraman
Function :
1) Must return a single value. Only one value can be return
from a function.
2) Can be called from a sql(insert,update,delete) or
assignment st.U can't execute the function directly.
3) Can have DML,DDL,TLC inside function. But those function
can not be called from a sql.
Procedure :
1) Procedure can return multiple values.Procedure is
optional to return a value.
2) Can be executed directly and u can't called procedure
from sql.
3)Can have DML,DDL,TLC inside Procedure.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the synonym of join?
What is the function of inner join?
Explain transaction server implicit?
What is not null constraint?
What is store procedure? How do they work?
How to write a query with a right outer join in ms sql server?
How to create a view using data from another view?
How do I create a partition table in sql server?
Explain Geography datatype in SQL Server
Tell me the difference between clustered and non-clustered index?
Write down the syntax and an example for create, rename and delete index?
What language is sql server written in?
Where in ms sql server is ’100’ equal to ‘0’?
What are the different editions available in sql server 2000?
How to create a Master database in SQL server ?