34 lines
2.0 KiB
Transact-SQL
34 lines
2.0 KiB
Transact-SQL
USE [site_fuchs]
|
|
GO
|
|
/****** Object: UserDefinedFunction [dbo].[ocms_locales] Script Date: 02.12.2020 21:05:05 ******/
|
|
DROP FUNCTION [dbo].[ocms_locales]
|
|
GO
|
|
/****** Object: UserDefinedFunction [dbo].[ocms_locales] Script Date: 02.12.2020 21:05:06 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
-- Author: <Author,,Name>
|
|
-- Create date: <Create Date,,>
|
|
-- Description: <Description,,>
|
|
-- =============================================
|
|
CREATE FUNCTION [dbo].[ocms_locales]
|
|
(
|
|
)
|
|
RETURNS @RET TABLE ([locale] varchar(5), [order] int)
|
|
AS
|
|
BEGIN
|
|
DECLARE @set_value varchar(2000) = ISNULL((SELECT [value] FROM [ocms_settings] where [key] = 'locales'), '*,de');
|
|
DECLARE @c char = ',';
|
|
|
|
INSERT INTO @RET
|
|
SELECT [value], [order] = ROW_NUMBER() OVER (ORDER BY CHARINDEX(@c + value + @c, @c + @set_value + @c))
|
|
FROM STRING_SPLIT(@set_value, @c);
|
|
|
|
RETURN;
|
|
END
|
|
GO
|
|
ALTER AUTHORIZATION ON [dbo].[ocms_locales] TO SCHEMA OWNER
|
|
GO
|