Interested to Buy Any Domain ? << Click Here >> for more details...
wht is the difference between truncat,drop in sqlserver
wht is the difference between function and stored procedure
- 3 Answers
- 8336 Views
- Apollo, I also Faced
- E-Mail Answers
Answer Posted / chandra shekher
truncate command will remove the table and again recreate
the table.
drop command will remove the table permanently from the
database.
Function must return a value where as stored procedure may
or may not return a value.
Function can return only one value where as stored
procedure can return multiple values.
Function can be used in sql query where as stored procedure
cannot be used in sql query.
Function is used to compute a value where as stored
procedure can be used to perform a task
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
how many columns can be used for creating index? : Sql dba
How to add new employee details in an employee_details table with the following details
What is index example?
What are the types of join in sql?
what are the type of locks ? : Sql dba
How does index help in query performance?
What is primary key sql?
What is aggregate function in sql?
What is the left table in sql?
How many types of functions are there in sql?
what is the difference between union and union all? : Sql dba
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
What is the clause we need to add in function body to return variable?
What operators deal with null?
What is sql rowcount?
