Do you know what is similarity and difference between truncate and delete in sql?


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

Post New Answer

More SQL Server Interview Questions

What are distributed partitioned views?

0 Answers  


What is the difference between indexing and hashing?

0 Answers  


How efficient you are in oracle and SQL server?

0 Answers   CGI,


what type of indexes physically sort data?

3 Answers  


Explain about thread and memory management process of SQL?

0 Answers  






i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  


can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  


How to drop an existing table?

0 Answers  


How to create a dml trigger using create trigger statements?

0 Answers  


What is difference between getdate and sysdatetime in sql server 2008?

0 Answers  


How column data types are determined in a view?

0 Answers  


What is difference between stored procedure and function?

3 Answers   L&T,


Categories