Does SDAC support SQL 2008 row constructors?

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Vladimir
Posts: 17
Joined: Fri 15 Aug 2008 18:09

Does SDAC support SQL 2008 row constructors?

Post by Vladimir » Tue 07 Apr 2009 14:51

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

shreq
Posts: 8
Joined: Fri 20 Mar 2009 11:26

Re: Does SDAC support SQL 2008 row constructors?

Post by shreq » Wed 08 Apr 2009 08:20

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.

Vladimir
Posts: 17
Joined: Fri 15 Aug 2008 18:09

Re: Does SDAC support SQL 2008 row constructors?

Post by Vladimir » Wed 08 Apr 2009 16:27

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?

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Thu 09 Apr 2009 15:08

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

shreq
Posts: 8
Joined: Fri 20 Mar 2009 11:26

Re: Does SDAC support SQL 2008 row constructors?

Post by shreq » Wed 15 Apr 2009 13:36

Vladimir wrote:[
How do you construct these?
Exactly:

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

Do you have problems with this SQL-code?

Post Reply