 | SQXVectorToTable Method |
Procedure VectorToTable [sql_variant] @ID, [Vector] @V
Namespace: sqx
Assembly: SQX (in SQX.dll) Version: 1.0.2.6 (1.0.2.6)
SyntaxC#
public static int VectorToTable( Object ID, Vector V )
Parameters
- ID
- Type: SystemObject
[sql_variant] - V
- Type: sqxVector
[Vector]
Return Value
Type: Int32[int] 0 success | -1 failure
RemarksVector to table procedure.
ID support data types; smallint, int, bigint, uniqueidentifier and datetime.
ID can be NULL, when NULL the field is suppressed.
ID support data types; smallint, int, bigint, uniqueidentifier and datetime.
ID can be NULL, when NULL the field is suppressed.
ExamplesSQL
declare @V sqx.Vector = sqx.RandomVector(3,1), @ID int = 10000 exec sqx.VectorToTable NULL, @V print '******' exec sqx.VectorToTable @ID, @V /* 1 2 3 ---------------------- ---------------------- ---------------------- 0.248668584157093 0.110743977181029 0.467010679872246 ****** ID 1 2 3 ----------- ---------------------- ---------------------- ---------------------- 10000 0.248668584157093 0.110743977181029 0.467010679872246*/
See Also