CREATE Proc blog_UTILITY_AddBlog
(
    @UserName nvarchar(50),
    @Password nvarchar(50),
    @Email nvarchar(50),
    @Host nvarchar(50),
    @Application nvarchar(50),
    @Author nvarchar(50),
    @Title nvarchar(100),
    @SubTitle nvarchar(250),
    @IsHashed bit,
    @Skin nvarchar(50)='AnotherEon001',
    @City nvarchar(50)
)

as

Declare @Flag int
Set @Flag = 55
if(@IsHashed = 1)
Set @Flag = 63

Insert blog_Config  (LastUpdated, UserName, Password, Email,     Title,       SubTitle,                     Skin, SkinCssFile,Application, Host, Author, TimeZone, Language, ItemCount, Flag,RegisterTime)
Values              (getdate(),@UserName, @Password, @Email, @Title,@SubTitle, @Skin,null,@Application, @Host,@Author,8,'zh-CHS',10,@Flag,getdate())

exec blog_InsertBlogProfile @@Identity,@City


GO