How to delete SQL script in SQL server 2000 edition?

Asked By Jimmy M Stahl 0 points N/A Posted on - 05/08/2013

Dear Techyv members. Please tell me how to delete SQL script in SQL server 2000 edition. How can I make this possible? Is there a step by step guide for this? Please kindly give me an overview for this kind of scripting. I would appreciate it if you will also include some of the issues and errors that could occur during the deletion process. 

• Status: Open
• Question Views: 756
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: ActionScript

Answered By George States 10 points N/A #183904

How to delete SQL script in SQL server 2000 edition?

 

There are different ways of deleting data from a table.

DELETE FROM TABLE_X deletes all data from a given table and should not have any issues in terms of performance with a well-structured table.

You may also want to delete only data that meets a given criteria e.g. deleting duplicate records. Best example is to use MAX(ID) to get the duplicates and nest the sub query in a delete statement.

As for SQL Server 2000 your best option is to use SET ROWCOUNT for deleting specific count of data rows.

Known issues start with the DELETE permissions which can be assigned to a specific user.

About George States

Questions
2

Answers
10

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 05/13/2013
• Question Category: ActionScript