sql statement insert into with select?

Question

I have a table with columns:

StudentID
Value1
Value2
Value3

...and I have three queries, each one will come with the studentID and a value(1 to 3) fields

What I would like to do is to update this table, with parallel values, if a student exists then update the corresponding column if not, create a new row.

I'm working with SQL Server 2005

Is this homework? Ideally you would use the merge syntax, but that wasn't available until SQL Server 2008. — JohnFx
– JohnFx, Commented Sep 27, 2012 at 14:11

Jim · Accepted Answer · 2012-09-27 14:26:47Z

2

Write it like you just said it:

IF EXISTS(SELECT * FROM table WHERE StudentID = @StudentID)
BEGIN
--update
END
ELSE
BEGIN
--insert
END

edited Sep 27, 2012 at 14:26

answered Sep 27, 2012 at 14:18

Jim

3,55724 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

sql statement insert into with select?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related