SQL Server 2008 New Features - Row Constructors: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
SQL Server 2008 New Features - Row Constructors

page 3 of 3

by Nidal Arabi
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 20789/ 28

Article Contents:

Summary

Although the row constructor feature is nifty, you have to pay attention when using it. For instance, whenever a row in the values lines fails to execute, the whole statement would fail resulting in no insert of data. So be careful when you are using it, especially when writing code that executes prepared statements. See you in the next article with a new feature.

« (Page 2)

View Entire Article

User Comments

Title: SQL Server 2008 New Features - Row Constructors
Name: onedaywhen
Date: 2010-07-12 8:50:57 AM
Comment:
Delete * From TblCustomer -- That's not legal SQL syntax. This plus other evidence (table names prefixed with 'Tbl', you didn't write your SQL DDL code, etc) makes me wonder if you are more comfortable with MS Access.

Title: SQL server 2008
Name: Vimal
Date: 2008-09-11 8:42:51 AM
Comment:
Very helpful

Title: SQL2008 - Row Constructors
Name: Srinivas
Date: 2008-09-04 6:34:30 AM
Comment:
Great

Title: SQL2008 - Row Constructors
Name: Mike
Date: 2008-09-03 9:35:45 PM
Comment:
That's great to know! Short, sweet, to the point.
Thanks!

Title: SQL 2000 / 2005
Name: Richard
Date: 2008-09-02 10:30:28 AM
Comment:
For SQL 2000 / 2005:

Insert into [Table] ([Columns])
Select [Row 1 Values]
Union Select [Row 2 Values]
Union Select [Row 3 Values]
(etc.)