Database Reference
In-Depth Information
declare @Label nvarchar(10)
select @Label = Label from dbo.vwVisibleLabels
where ID = @ColumnLabel
if @Label is null
begin
set @Data = 'NULL'
end
else
begin
set @Data = @ColumnData
end
return @Data
END
GO
Create FUNCTION [dbo].[GetCLabel](@ID int)
RETURNS nvarchar(10)
AS
BEGIN
declare @Label nvarchar(10)
select @Label = Label from [dbo].[tblUniqueLabel]
where ID = @ID
return @Label
END
GO
CREATE FUNCTION [dbo].[GetBCUserView](@label int)
RETURNS nvarchar(10)
AS
BEGIN
declare @NewLabel nvarchar(10)
declare @ViewLabel nvarchar(10)
declare @BreakedLabel nvarchar(10)
declare @UserLabelID int
declare @NumericLabel int
declare @Counter int
set @NumericLabel = 0
set @Counter = 1
set @NewLabel = ''
select @UserLabelID = [dbo].GetLabelID([dbo].
[GetUserLabel]())
select @BreakedLabel = [dbo].BreaklLabe(@label)
WHILE (@Counter < = @UserLabelID)
BEGIN
set @NumericLabel = @NumericLabel+(POWER(4, @Counter-1)
*CAST(SUBSTRING(@BreakedLabel,@Counter,1) AS int))
Search WWH ::




Custom Search