Checking if a field exists in a table before adding it to another table

[Twyce]

Hi Guys If anyone can help me with this it would be greatly appreciated. K here is what's happening.I am supposed to check if a student exists in the STUDENT table and then check if a module exists in the MODULE table.if they exist in both tables I must add the student(StudentNumber) and the module(ModuleCode) to the STUDENTMODULE table(register the student). How do i do this plz help

[David Mujica]

To find if a record exists, you would use a select statement ... select count(*) from student where studentNumber = [myStud] if count = 0 then insert StudentNumber,ModuleCode into STUDENTModule values (myStud,myMoodule) This is not actual code, but pseudocode meant to point you in the right direction. I won't do your homework for you. :)

[Blue_Boy]

if(select count(*) from students where studentnamecolumn = 'studentname') = 0 begin insert into students values (value1,value1......) end

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.

[Pete OHanlon]

You can do this with an insert into table, e.g.

insert into mytable (value1, value2, value3)
select @value1, @value2, @value3
where @myitem not in (select myitem from table2)

Deja View - the feeling that you've seen this post before.

My blog | My articles