What is the difference between TRUNCATE and DROP?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

which one will take 1st priority in case of insert statement and select statement???

2 Answers   HCL,


What is the purpose of indexing?

0 Answers  


What do you understand by triggers and mention the different types of it?

0 Answers  


One table how may column and Primary key

3 Answers  


What are functions

3 Answers  






How to display a past time in days, hours and minutes?

0 Answers  


What is the sql server 2000 version number?

0 Answers  


Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  


Explain throw statement in sql server 2008?

0 Answers  


What happens if strings are casted into wrong code pages in ms sql server?

0 Answers  


How to change the password of a login name in ms sql server?

0 Answers  


What are the elements of dbms?

0 Answers  


Categories