You can use this if you have no foreign keys to other tables:
truncate table TableName
If you want all tables:
sp_msforeachtable 'delete ?'
With the help of the SQL count ...READ MORE
There are three types of user-defined functions, ...READ MORE
I understand your problem,
You can try ...READ MORE
Mass killing operation saves time. Do it ...READ MORE
To answer your query, note that CTEs ...READ MORE
With 200 records currently, I want to ...READ MORE
How do I query the DateTime database ...READ MORE
I only need to choose the given ...READ MORE
The @CustID denotes a parameter for which ...READ MORE
Go to Start > Programs > Microsoft SQL Server > Enterprise Manager.
Right-click the SQL ...READ MORE
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.