please differentiate between delete and truncate?


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

Post New Answer

More SQL Server Interview Questions

explain different types of constraints? : Sql server database administration

0 Answers  


Can we perform backup restore operation on tempdb? : sql server database administration

0 Answers  


What is efficiency data?

0 Answers  


What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

0 Answers  


WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

1 Answers   Synergy,






Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  


Which Model uses the SET concept

0 Answers   Infosys,


What is the stuff and how does it differ from the replace function?

0 Answers  


What is meant by indexing?

0 Answers  


How to genrate automaticlly empid like gt001

4 Answers  


What function does a database engine serve in the sql server?

0 Answers  


Does group by sort data?

0 Answers  


Categories