spInsertTag

    create procedure dbo.spInsertTag(@tag nvarchar(255)) as
    declare @codetableid int
    select @codetableid=id from dbo.sitecodetables where guid='C30B9F19-EF1F-4c13-AB2A-A1428FBABA94'
    DECLARE @MyGUID AS uniqueidentifier
    SET @MyGUID = newid()
    insert into dbo.sitecodetableentries(CodeTablesId, Description, EntryGuid)
    values(@codetableid, @tag, @MyGUID)