It's pretty common to find strings like that in syscomments:

/*

The procedure updates values stored in table SessionValues

*/

CREATE Procedure abc_SessionValuesUpdate (a int) AS

SET NOCOUNT ON

BEGIN

UPDATE SessionValues SET Value = @Value WHERE ID = @ID AND Name = @Name

IF @@ROWCOUNT = 0

INSERT INTO SessionValues values (@ID,@Name,@Value)

END

The logic of the solution above will fail for all such cases.