Devart Forums

Does SDAC support SQL 2008 row constructors?
Is there any way to use these in SDAC, at least INSERT type, and how?

Like this:

CREATE TABLE t (a int, b char);
GO
INSERT INTO t VALUES (1,'a'), (2, 1);
GO

See ms help at

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/1054c76e-0fd5-4131-8c07-a6c5d024af50.htm

Vladimir wrote: CREATE TABLE t (a int, b char);
GO
INSERT INTO t VALUES (1,'a'), (2, 1);
GO

I use row constructors in SDAC without any problems.

shreq wrote:

Vladimir wrote: CREATE TABLE t (a int, b char);
GO
INSERT INTO t VALUES (1,'a'), (2, 1);
GO

I use row constructors in SDAC without any problems.

How do you construct these?

To execute this SQL query you can use TMSSQL or TMSQuery.

Vladimir wrote:[
How do you construct these?

Exactly:

INSERT INTO t VALUES (1,'a'), (2, 1);

Do you have problems with this SQL-code?