wht is the difference between truncat,drop in sqlserver
wht is the difference between function and stored procedure
- 3 Answers
- 7415 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 ddl commands?
Explain the difference between triggers and constraints?
What is compilation error in pl sql?
What is the use of partition by in sql?
What is the difference between alter trigger and drop trigger statements?
Do ddl statements need commit?
How do temporal tables work?
What do we need to check in database testing?
What are the advantages of sql?
What is the purpose of using pl/sql?
What is sorting in sql?
How does cross join work in sql?
Does sql view stored data?
What is right join sql?
What is information schema in sql?
