Explain the difference between delete,drop and truncate in SQL Server?


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

Post New Answer

More SQL Server Interview Questions

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

0 Answers  


What is normalization? What number of normalization shapes are there?

0 Answers  


I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,


what is blocking? : Sql server database administration

0 Answers  


wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform

1 Answers   Idea,






What is the stuff?

0 Answers  


What is the default value of an integer data type in sql server 2005?

0 Answers  


What will happen if a column containing char type data is changed to the nchar data type?

0 Answers  


What is the difference between resultset and resultsetmetadata?

0 Answers  


Can Somebody tell me the difference between Clustered & Non- Clustered Index??

5 Answers   Progressive,


What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,


What happens if null values are involved in bitwise operations?

0 Answers  


Categories