205222/delete-all-the-records
You can use this if you have no foreign keys to other tables:
truncate table TableName
or
delete 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
Hi Santanu, I understand your problem, You can try ...READ MORE
Hello kartik, 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
Solution Go to Start > Programs > Microsoft SQL Server > Enterprise Manager. Right-click the SQL ...READ MORE
OR
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.