creare tabella numeri

GO / Funzione di generazione numeri interi fino ad un max di 256 / CREATE FUNCTION dbo.GetNums @n AS BIGINT RETURNS TABLE AS RETURN WITH L0 AS SELECT 1 AS c UNION ALL SELECT 1 , L1 AS SELECT 1 AS c FROM L0 AS A CROSS JOIN L0 AS B , L2 AS SELECT 1 AS c FROM L1 AS A CROSS JOIN L1 AS B , L3 AS SELECT 1 AS c FROM L2 AS A CROSS JOIN L2 AS B , Nums AS SELECT ROW_NUMBER OVER ORDER BY SELECT NULL AS n FROM L3 SELECT TOP @n n FROM Nums ORDER BY n;
creare tabella numeri creare tabella numeri
Tags: creare tabella numeri
| Some Articles: creare tabella numeri | Original post: creare tabella numeri | Technorati tag: creare tabella numeri | Virgilio tag: creare tabella numeri