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 types of integrity are enforced by a foreign-key constraint

1 Answers  


What are subquery and its properties?

0 Answers  


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

0 Answers  


What guidelines should be followed to help minimize deadlocks?

0 Answers  


What happens if time-only values are provided as date and time literals?

0 Answers  






What is difference between index and primary key?

0 Answers  


What is join and name different type of joins?

0 Answers  


What is the purpose of indexing?

0 Answers  


What is side by side migration in sql server?

0 Answers  


can we call functions from stored procedure in SQL Server 2005 ? How?

3 Answers  


What is the role that is required for killing a process What is the role that is required for creating a linked server

1 Answers   CarrizalSoft Technologies, IBM,


hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  


Categories