function can return value ,procedure also return value through
out parameter then what is the difference?
Answer Posted / damodharan
function should always return only one value
but procedure may return a value value it may one or more
than one value
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are commit, rollback, and savepoint?
How do I truncate a sql log file?
Why function is used in sql?
How to rename a table?
What is view? Can we update view
Is sqlite free?
What are the triggers associated with image items?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
What is t sql used for?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
What are the sql versions?
What is the trigger in sql?
What is sql key?
How do we use distinct statement? What is its use?
How do you rename a table in sql?