Untitled

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:              Matthew Raymer, Developer
-- Create date: April 16, 2010
-- Description: Insert a record in the rssfeeds table
-- =============================================
CREATE PROCEDURE sps_rssfeeds_update
        @p_rssid INT,
        @p_url VARCHAR(1024),
        @p_name VARCHAR(50)
AS
BEGIN
      SET NOCOUNT ON;

      UPDATE RSSFEEDS
      SET
            URL = @p_url,
            Name = @p_name
           WHERE RSSID = @p_rssid
END
GO