SQL Server 2008 New Features - Row Constructors
page 3 of 3
by Nidal Arabi
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 20655/ 52


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.

View Entire Article

User Comments

Title: SQL Server 2008 New Features - Row Constructors   
Name: onedaywhen
Date: 2010-07-12 8:50:57 AM
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
Very helpful
Title: SQL2008 - Row Constructors   
Name: Srinivas
Date: 2008-09-04 6:34:30 AM
Title: SQL2008 - Row Constructors   
Name: Mike
Date: 2008-09-03 9:35:45 PM
That's great to know! Short, sweet, to the point.
Title: SQL 2000 / 2005   
Name: Richard
Date: 2008-09-02 10:30:28 AM
For SQL 2000 / 2005:

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

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-05-18 2:49:17 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search