MS SQL

Delete Rows

Please support our MS SQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Nov 2009

Posts: 1

Reputation: Kaddolas is an unknown quantity at this point

Solved Threads: 0

Kaddolas

Offline

Newbie Poster

Delete Rows

Nov 8th, 2009

Hi

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

 Help with Code Tags 
 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)

•

Join Date: Feb 2009

Posts: 3,464

Reputation: sknake has much to be proud of

Solved Threads: 629

sknake

Offline

.NET Enthusiast

Nov 8th, 2009

 Help with Code Tags 
 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.

Scott Knake
Custom Software Development
Apex Software, Inc.

•

Join Date: Apr 2009

Posts: 229

Reputation: mail2saion is an unknown quantity at this point

Solved Threads: 36

mail2saion mail2saion is offline

Offline

Posting Whiz in Training

Nov 10th, 2009

Also you can write:

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