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
- 8298 Views
- Apollo, I also Faced
- E-Mail Answers
Answer Posted / srilekha
TRUNCATE:it will delete all the records at a time but not a
stucture.
DROP:it will delete the table permanently from database;
PROCEDUE:it may be return value,it will not used in sql
queries
FUNCTION:it returns a value,it will used in sql queries
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the events on which a database trigger can be based?
Is sql database free?
What are the types of functions in sql?
How to look at the current sql*plus system settings?
Can procedure in package be overloaded?
what are the advantages of using stored procedures? : Sql dba
When can we use the where clause and the having clause?
What are the limitations of sql express?
what is denormalization. : Sql dba
Explain how exception handling is done in advance pl/sql?
What are the types of variable use in pl sql?
What are the three forms of normalization?
What are data types in pl sql?
Are subqueries faster than joins?
How are sql commands classified?
