How to create a SP to update multiple fields at once?

How to create a SP to update multiple fields at once?

I have the following code but its not working.

CREATE PROCEDURE [dbo].[edit_notes]

    @COMID INT,
	@visible INT,
    @comments NVARCHAR(MAX),
    @updatedby INT,
    @lastupdate DATETIME,
    @commby BIT,
    @importance INT,
    @visibleemployer BIT
AS
UPDATE dbo.Casecomments
    Set Visible = @visible
    Set Comments = @comments
    Set Updatedby = @updatedby
    Set Lastupdate = @lastupdate
    Set @commby = @commby
    Set @importance = @importance
    Set @visibleemployer = @visibleemployer

WHERE COMMID = @COMID
 

Select allOpen in new window