what is the difference between Delete and Truncate command in SQL

Question Posted / irfan

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

More SQL Server Interview Questions

Explain what is the purpose of sql profiler in sql server?

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

What is entity data services?

How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

What options are available to audit login activity? : sql server security

How to select Distinct columns from the table, table having 20 columns and i want all coulmns

sql database suspect We have a sql database that is showing as suspect. How can we recover?

What are the advantages of using third-party tools?

Do you know exporting and importing utility?

What is tempdb database? : SQL Server Architecture

How can you know if the row fetched from cursor is still valid in underlying table?

For more SQL Server Interview Questions Click Here