TRUNCATE:it will delete all the records at a time but not a stucture. DR

wht is the difference between truncat,drop in sqlserver
wht is the difference between function and stored procedure

Question Posted / srilekha

3 Answers
8122 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

Please Help Members By Posting Answers For Below Questions

How does stored procedure reduce network traffic?

965

What are the different types of tables in sql?

929

What is denormalization in a database?

993

Is it mandatory for the primary key to be given a value when a new record is inserted?

1139

What is nested table in pl sql?

1004

What is the difference between a procedure and a function?

1011

What is sql*plus?

1016

How do I turn a list into a table?

905

What does := mean in pl sql?

989

How many sql core licenses do I need?

882

What is where clause in sql?

982

what is a unique key ? : Sql dba

1025

What is multiple partition?

919

What is the difference between between and in condition operators?

939

how to use case expression? : Sql dba

958