Samuele E. Locatelli
24 lines
498 B
Transact-SQL
24 lines
498 B
Transact-SQL
|
|
-- =============================================
|
|
-- STORED stp_getValidValues
|
|
--
|
|
-- Author: S.E.L.
|
|
-- Create date: 2011.05.26
|
|
-- Description: gestione selezione dati parametrici
|
|
-- =============================================
|
|
create PROCEDURE [dbo].[stp_listValues_getValidValues]
|
|
(
|
|
@TableName NVARCHAR(50),
|
|
@FieldName NVARCHAR(50)
|
|
)
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT value, label
|
|
FROM ListValues
|
|
WHERE TableName = @TableName
|
|
AND FieldName = @FieldName
|
|
ORDER BY ordinal
|
|
END
|