SQL query If field exists update else insert

You can execute an UPDATE query and find out if it was succesfull. If no success execute an INSERT query.

yes, do a UPDATE first, then INSERT if @@rowcount is 0.
best would be to put that into a stored proc...

CREATE PROC add_member
( @userID int, @FirstName varchar(100), @lAstname varchar(100), dob datetime, @height decimal(10,2), @weigth(10,2))
AS
BEGIN
UPDATE Members
  SET Firstname = @FirstName
    , lastName = @lastName
    , dob = @dob
    , height = @height
    , weight = @weight
WHERE UserID = @UserID 
IF @@ROWCOUNT = 0 
  INSERT INTO Members
  (UserID, FirstName, LastName, DOB, Height, Weight)
   VALUES (@UserID,@FirstName,@LastName,@DOB,@Height,@Weight) 
END

Select allOpen in new window

im not sure how to create PROC's in the query builder of visual studio :/

you don't, you just have to "run" the CREATE PROC statement.

im kinda confused with how to do it, ive sent a screen shot of what im trying to use for it.

I've tried doing this without the PROC statement

BEGIN UPDATE Members
    SET FirstName = @FirstName
WHERE UserID = @UserID
IF @@ROWCOUNT = 0
INSERT INTO Members (FirstName) VALUES (@FirstName)
END

But i get this error :

SQL Execution Error.
....
Error Source :.Net SQLClient Data Provider
Error Message :Must declare the scalar variable "@FirstName".


Im sorry if im annoying you im very new to this, and its soo annoying :P, thanks for the help
screenshot.JPG

sorry, I definitively DONT use the visual tools... they take too much control :)

I use the query windows of the sql management to build/modify procedures...

i just tired the following: and no luck either :( this thing is annoying me:(
Table :  UserID FirstName LastName DOB Height Weight

IF EXSTS ( SELECT * FROM members WHERE userID = @userID)
BEGIN
     UPDATE members SET FirstName = 'testupdateinput' WHERE userID = @userID
END
ELSE
BEGIN
     INSERT INTO members (FirstName) VALUES  ('Test')
END

thanks