CREATE PROCEDURE spUpd_MyContacts
    @ContactID      int
  , @FirstName      nvarchar(50)
  , @LastName       nvarchar(50)
  , @Phone          nvarchar(25)
AS
   UPDATE MyContacts 
   SET FirstName = @FirstName
     , LastName = @LastName
     , Phone = @Phone

spUpd_MyContacts 5, 'Betrice', 'Rubble', '(222) 234-7654' 

quote:

---

Is this code suppose to update all records?

---

quote:

---

Or just the record with primary key of 1?

---

quote:

---

Originally posted by SIMPLicity_

It really does that way!

If you'd like to update only one record, you have to specify it...

So, add "WHERE ID = @ContactID" clause in UPDATE statement (after SET.....).

---

quote:

---

Originally posted by GilaMonster

quote:

---

Is this code suppose to update all records?

---

Yes.

quote:

---

Or just the record with primary key of 1?

---

Where in the update statement is there anything to say update just the row with ContactID = 5? The value is passed to the procedure, but absolutely nothing is done with the value in the procedure.

There is no limitation on that update, it just says update the table and set the column values.



--
Gail Shaw
SQL Server MVP

---

quote:

---

Originally posted by The_Utimate_Novice


I am in a discussion with the author and will post a link or the answers when the matter is resolved.

Thanks everyone!

TUN

---

CREATE PROCEDURE uspUpdateRecord
  @Company        VARCHAR(100)
, @CompanyLoc     VARCHAR(50)
, @Address        VARCHAR(30)
, @City           VARCHAR(25)
, @State          CHAR(2)
, @Zip            CHAR(9)
, @Phone          CHAR(10)
, @Contact        CHAR(30)
, @Support        CHAR(1)
AS

UPDATE tblSupportCall

SET Address      = @Address
  , City         = @City
  , State        = @State
  , Zip          = @Zip
  , Phone        = @Phone
  , Contact      = @Contact
  , Support      = @Support
  
WHERE Company  = @ Company AND  CompanyLoc = @CompanyLoc;

So if we have a company in our database or table called Office Max Located in New York
We can use the company name and location to identify the company and update all other attributes.

uspUpdateRecord 'Office Max', 'New York','99689 Ruggs Street', 'New York', 'NY',
'6719','7182342345','Victor Moon','N';