what is difference between procedure and function
Answer Posted / shanmukha srinivas
procedure can run in sql block like
begin
sp_procedure_name(input parameters);
end;
function can run in sql block like
select sf_function_name(input paramters)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to do backup entire database? : Transact sql
What is partition by in sql?
What are inner outer left and right joins in sql?
How many types of normalization are there?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
what are all the common sql function? : Sql dba
What is the usage of sql functions?
Why partition by is used in sql?
What are the benefits of triggers?
What is the difference between microsoft access and sql?
Why do we need sharding?
what does the t-sql command ident_current does? : Transact sql
how many sql ddl commands are supported by 'mysql'? : Sql dba
how to convert character strings to dates? : Sql dba
What is sql stand for?