spSetDefaultSiteURL

CREATE PROCEDURE dbo.spSetDefaultSiteURL
    @URL nvarchar(255)
AS
BEGIN
    declare @DefaultSiteID int
    set @DefaultSiteID = (select Value from dbo.Setting where ID = 1)    

    delete from dbo.CMSSITESETTING
    where CMSSITESETTING.CLIENTSITESID = @DefaultSiteID
    and CMSSITESETTING.ENUMID in (10,11)

    insert into dbo.CMSSITESETTING (ENUMID, CLIENTSITESID, SETTING, VALUE)
    values (11, @DefaultSiteID, 'AppPathURL', @URL )

    insert into dbo.CMSSITESETTING (ENUMID, CLIENTSITESID, SETTING, VALUE)
    values (10, @DefaultSiteID, 'PageBaseURL', @URL + 'Page.aspx' )
END