What is the distinction amongst delete and truncate?


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

Post New Answer

More SQL Server Interview Questions

A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

2 Answers   Sapient,


What is the system function to get the current user's user id?

2 Answers   HCL,


How do you open a cluster administrator?

0 Answers  


What do you mean by authentication modes in sql server?

0 Answers  


What command is used to rename the database?

0 Answers  






Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  


What is resource db in sql server?

0 Answers  


What is apply operator in sql?

0 Answers  


What is coalesce in sql server?

0 Answers  


Tell me extended events in sql server 2008?

0 Answers  


Can an automatic recovery be initiated by a user?

0 Answers  


what is the primary use of the model database? : Sql server administration

0 Answers  


Categories