spInsertCodeTableEntries
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CodeTableGuid | uniqueidentifier | IN | |
| @CSVEntries | nvarchar(max) | IN |
Definition
Copy
create procedure [dbo].[spInsertCodeTableEntries](
@CodeTableGuid uniqueidentifier,
@CSVEntries nvarchar(max)
) as
declare @codetableid int
select @codetableid=id from dbo.sitecodetables where guid=@CodeTableGuid
insert into dbo.sitecodetableentries (CodeTablesId, Description, EntryGuid)
select @codetableid, [value], newid()
from fnMakeVarCharTableFromString(@CSVEntries, ',')
GO