Using deterministic sql inserts

[ShawnMolloy]

Hello,

I'd like to run a check on a table before I insert a new row. I want to check if the IP Address in this table exists before the insert:

INSERT INTO views VALUES (@IpAddress, @VideoId)

Would I just run a select for the ipaddress and then count the result set rows?

Thanks,

Shawn Molloy
Seattle, WA

 

[gmmastros]

If Exists(Select * From TableName Where IpAddress = @IpAddress)
  Begin
    -- Record exists, update the record???
  End
Else
  Begin
    -- Insert the record
    INSERT INTO views VALUES (@IpAddress, @VideoId)
  End

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom