wht is the difference between truncat,drop in sqlserver
wht is the difference between function and stored procedure
- 3 Answers
- 7410 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
What are pl sql procedures?
Can we enter data in a table in design view?
What is the use of sqlerrd 3?
Explain select statements in sql?
What is database white box testing and black box testing?
Is left join and outer join same?
What is the purpose of cursors in pl/sql?
how do you know the version of your mysql server? : Sql dba
How do you get column names only for a table (sql server)?
what does it mean to have quoted_identifier on? : Sql dba
What is using in sql?
What is the difference between a primary key and a clustered index?
How do I find duplicates in the same column?
What is equi join in sql?
How many types of privileges are available in sql?
