Inserting a values with condition

Question

Using SQL Server 2005

I want to insert a table with where condition

Table1 column Name - ID, Name, Dept, Rank

Query

Insert into table1 values('1', 'Raja' 'IT', 'True') where Rank <> 'False'

Need Query Help

Use an UPDATE statement instead of INSERT

Shankar R10N
– Shankar R10N

2010-02-22 04:41:06 +00:00
Commented Feb 22, 2010 at 4:41 — Shankar R10N
– Shankar R10N, Commented Feb 22, 2010 at 4:41

Ralph Shillington · Accepted Answer · 2010-02-22 04:39:25Z

3

insert into table 1 select '1', 'raja', 'it', 'true' from SomePlaceWhereRankExists where rank <> 'false'

It's not clear where 'Rank' is coming from in your pseudo code.

answered Feb 22, 2010 at 4:39

Ralph Shillington

21.2k24 gold badges95 silver badges156 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Martin Booth · Accepted Answer · 2010-02-22 04:45:03Z

0

Perhaps you're attempting something along the lines of:

IF @rank <> 'false'
  Insert into table1 values('1', 'Raja' 'IT', 'True')

You're not particularly clear about your goal however. Are you trying to update existing records or insert new ones? If you're inserting new ones, what are you trying to achieve using a where clause?

answered Feb 22, 2010 at 4:45

Martin Booth

8,59533 silver badges31 bronze badges

Collectives™ on Stack Overflow

Inserting a values with condition

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related