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): 4063/ 113

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.


View Entire Article

Article Feedback

Title:  
Name:  
Url: ( Optional )
Comment:  
Please add 2 and 3 and type the answer here:

User Comments

Title: SQL server 2008   
Name: Vimal
Date: 9/11/2008 8:42:51 AM
Comment:
Very helpful
Title: SQL2008 - Row Constructors   
Name: Srinivas
Date: 9/4/2008 6:34:30 AM
Comment:
Great
Title: SQL2008 - Row Constructors   
Name: Mike
Date: 9/3/2008 9:35:45 PM
Comment:
That's great to know! Short, sweet, to the point.
Thanks!
Title: SQL 2000 / 2005   
Name: Richard
Date: 9/2/2008 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.)






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


©Copyright 1998-2009 ASPAlliance.com  |  Page Processed at 1/7/2009 8:42:18 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search