Give main differences between "Truncate" and "Delete".

Question Posted / abdul mutlib khan

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

More SQL Server Interview Questions

Explain the dirty pages?

How to concatenate two strings in SQL Server.

How do you manipulate data?

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

What are types of storage modes? : sql server analysis services, ssas

How ssrs maintain security?

How to insert a new row into a table with "insert into" statements in ms sql server?

What are binary string data types in ms sql server?

Can we use where and having clause together?

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

How to bind a view to the schema of the underlying tables?

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

For more SQL Server Interview Questions Click Here