MS SQL

MS SQL RSS

Delete Rows

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Nov 2009

Posts: 1

Reputation: Kaddolas is an unknown quantity at this point

Solved Threads: 0

Kaddolas

Offline

Newbie Poster

Delete Rows

21 Days Ago

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; 14 Days Ago 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,215

Reputation: sknake has much to be proud of

Solved Threads: 572

sknake

Offline

.NET Enthusiast

21 Days Ago

 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: 217

Reputation: mail2saion is an unknown quantity at this point

Solved Threads: 31

mail2saion mail2saion is offline

Offline

Posting Whiz in Training

19 Days Ago

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