Click or drag to resize
sqx

SQXXTable Method

Function [table] XTable([float] StartValue, [float] EndValue, [float] StepValue)

Namespace:  sqx
Assembly:  SQX (in SQX.dll) Version: 1.0.2.6 (1.0.2.6)
Syntax
C#
Copy
public static IEnumerator XTable(
	SqlDouble StartValue,
	SqlDouble EndValue,
	SqlDouble StepValue
)

Parameters

StartValue
Type: System.Data.SqlTypesSqlDouble
[float]
EndValue
Type: System.Data.SqlTypesSqlDouble
[float]
StepValue
Type: System.Data.SqlTypesSqlDouble
[float]

Return Value

Type: IEnumerator
[table]
Remarks
Generate table with float values starting at StartValue and ending at EndValue with step StepValue.
StepValue > 0

NOTE: XTable is asynchronous, when sequential numbers are needed use ORDER BY clause.

NOTE: Limit ID = sqx.MaxBigInt() = 9223372036854775807

Attributes

IsDeterministic = true, IsPrecise = true, DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.None, TableDefinition = "ID bigint, Value float"
Examples
SQL
Copy
SELECT * FROM sqx.XTable(0, 1, 0.1)
GO
/*
ID                   Value
-------------------- ----------------------
1                    0
2                    0.1
3                    0.2
4                    0.3
5                    0.4
6                    0.5
7                    0.6
8                    0.7
9                    0.8
10                   0.9
11                   1*/

SELECT * FROM sqx.XTable(1, 0, 0.1)
GO
/*
ID                   Value
-------------------- ----------------------
1                    1
2                    0.9
3                    0.8
4                    0.7
5                    0.6
6                    0.5
7                    0.4
8                    0.3
9                    0.2
10                   0.1
11                   0*/
See Also