Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2014-09-23
6
Medium Priority
?
128 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:Ernesto
  • 2
  • 2
  • 2
6 Comments
 

Author Comment

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

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 53

Accepted Solution

by:
Vitor Montalvão earned 2000 total points
ID: 40340977
So, you have the correct DELETE statement.
What you need more?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:Ernesto
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 49

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 53

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

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

578 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