Delete Rows

Expand Post »

Hi

I wonder how I do to remove usersid from 1915 to 1945 for example in MS Sql?

sql Syntax (Toggle Plain Text)
DELETE FROM [dbo].[user] WHERE user ID = 1915 to userID 1945
Delete from [dbo].[user] where user ID = 1915 to userID 1945

When i add that i get this message:

Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'to'.
Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'to'.

Can someone please tell me what is wrong?

Last edited by peter_budo; Nov 15th, 2009 at 4:39 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)

Similar Threads

Delete all rows from table in javascript in JavaScript / DHTML / AJAX
Delete rows from database in MySQL
Javascript- Hoe to delete rows by id. in JavaScript / DHTML / AJAX
Change and delete rows in a sql-database in Java
How do i get a datagrid to update & delete rows. in ASP.NET

Kaddolas

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Nov 2009

Permalink

Nov 8th, 2009

Re: Delete Rows

MS SQL Syntax (Toggle Plain Text)
DELETE FROM User WHERE UserId >= 1915 AND UserId <= 1945
Delete from User Where UserId >= 1915 and UserId <= 1945

There is also a BETWEEN operator you could use.

sknake

Featured Poster

Reputation Points: 1749

Solved Threads: 735

Senior Poster

Offline

3,948 posts
since Feb 2009

Permalink

Nov 10th, 2009

Re: Delete Rows

Also you can write:

MS SQL Syntax (Toggle Plain Text)
DELETE FROM User WHERE UserId BETWEEN 1915 AND 1945
DELETE FROM User WHERE UserId BETWEEN 1915 AND 1945

mail2saion

Reputation Points: 26

Solved Threads: 44

Posting Whiz in Training

Offline

247 posts
since Apr 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Smart Searches

Next Thread in MS SQL Forum Timeline: is there a way to make an image data type as index?

DaniWeb Message

Cancel Changes

User Name
Password