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
- 8457 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 is nosql example?
How does rowid help in running a query faster?
How to select unique records from a table?
Is sql the best database?
Can we use view in stored procedure?
Can we use two order by clause in query?
How do you explain an index?
What are the basic sql commands?
What are field types?
What is difference between rank () row_number () and dense_rank () in sql?
List the various privileges that a user can grant to another user?
how many values can the set function of mysql take? : Sql dba
How much does a sql dba make? : SQL DBA
What is the function that is used to transfer a pl/sql table log to a database table?
Compare sql & pl/sql
