What is the difference between truncate and delete commands?


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

Post New Answer

More SQL Server Interview Questions

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,


What are various ways to enhance the ssrs report?

0 Answers  


Why Master database is required?

0 Answers   Abacus,


What are the main differences between #temp tables and @table variables and which one is preferred?

0 Answers  


How do I find the port number for sql server?

0 Answers  


what is a self join? Explain it with an example? : Sql server database administration

0 Answers  


How to test odbc dsn connection settings?

0 Answers  


What have included columns when we talk about sql server indexing?

0 Answers  


How do you read transaction logs

1 Answers  


explain how to create a new schema in a database? : Sql server database administration

0 Answers  


Do you know how to send email from database?

0 Answers  


How you can get a list of all the table constraints in a database? : Sql server administration

0 Answers  


Categories