SQL Server 2008 New Features - Row Constructors
page 1 of 3
Published: 27 Aug 2008
Abstract
Microsoft SQL Server 2008 has brought many new features. In this article, Nidal sheds light on a new feature called row constructors with the help of relevant SQL Statements. This feature is intended to increase productivity and ease the lives of developers.
by Nidal Arabi
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 20851/ 41

Introduction

Microsoft SQL Server 2008 with its release included some new features that some of us (as developers) will find interesting and useful. In this article, which will be followed by others, I will try to shed some light on the row constructer feature (a nifty addition) as attributed to the family of T-SQL.

About The Feature

Ever spent time to fill a table with T-SQL insert statement where you have multiple records of the same format to insert into a single table. Well, row constructors come to the rescue. This feature allows you to effect multiple insertions of data using a single insert statement.

Requirements

In order to apply the article procedures, you should have installed any version of Microsoft SQL Server 2008 (Express, Standard, Developer, or Enterprise).


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.)






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


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-03-29 4:17:11 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search