Solved

i mess up i want to delete all regs >5633 in sql server is that posible

Posted on 2014-09-23
6
104 Views
Last Modified: 2014-10-20
i mess up i want to delete all regs >5633 in sql server is that posible

sql server
0
Comment
Question by:edo60
  • 2
  • 2
  • 2
6 Comments
 

Author Comment

by:edo60
ID: 40340447
i want to
delete from instrumentos where recno>5633
tsm
0
 
LVL 48

Expert Comment

by:PortletPaul
ID: 40340521
delete from instrumentos where recno>5633


Well, the syntax looks correct, but ...
Make sure you have a backup in case something goes wrong.

How many records will you be deleting? (if it is a lot consider doing it in smaller batches)

Are there any constraints? (i.e. are other tables affected by this)?

Only you know that database; We only know as much about that db as you have included on this page.
0
 
LVL 45

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40340977
So, you have the correct DELETE statement.
What you need more?
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

Author Comment

by:edo60
ID: 40342431
i mean
i have not the recno field,
is any way to have the reference of the recnumber by the system and procede?
tsm
0
 
LVL 48

Expert Comment

by:PortletPaul
ID: 40343067
can you provide the complete table definition? (field names, types etc.)

and perhaps a few rows of data too?

If you do not have a [recno] field how do you know that you need to delete where recno > 5633 ?
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 40343322
Are you saying that recno isn't a column from a table? If so, do you want to mean ROWNUMBER?
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Suggested Solutions

Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now