Files
WebGIM/GimDB/dbo/Stored Procedures/stp_listValues_getByTable.sql
2017-01-27 22:26:50 +01:00

23 lines
383 B
Transact-SQL

/***************************************
* STORED stp_listValues_getByTable
*
* ottiene elenco campi data Table
*
* Steamware, S.E.L.
* mod: 2014.08.04
*
****************************************/
CREATE PROCEDURE [dbo].[stp_listValues_getByTable]
(
@TableName NVARCHAR(50)
)
AS
SELECT *
FROM ListValues
WHERE TableName = @TableName
ORDER BY FieldName, ordinal
RETURN