Wednesday, August 06, 2008

SQL Server 2008 New Feature - Insert statement supports multiple record

With SQL Server 2008, we have got an interesting enhancement in Insert statement.

Originally from previous releases of SQL Server until SQL Server 2005, an INSERT statement was supposed to accept set of values for one row/record at a time.

INSERT INTO Customers (Name,Qty,Price)
Values('A',2,12)

INSERT INTO Customers (Name,Qty,Price)
Values('B',3,24)


But with SQL Sever 2008, we can insert multiple rows/records at a time just separated by comma as a delimiter:

INSERT INTO Customers (Name,Qty,Price)
Values('A',2,12),('B',3,24)


This will help the developers to save their time while inserting data.

Sunday, August 03, 2008

Review of uCertify's C# 70-528 exam .NET Preparation Kit

I feel that ASP.NET 2.0 has not been so easy to understand for many .NET folks. Likewise being a Microsoft Certified Technology Specialist in .NET 2.0 Web Applicaions is a complex task too.

You can achieve it, if right methodology of learning and practicing the concepts has been used.

Ucertify's preparation kit titled
70-528-CSHARP - C#.NET 2.0 Web-based Application Development practice test will help you learn fast, understand completely and qualify the test for sure.

The preparation kits of ucertify are designed to give you look and feel of real test environment and you will find yourself more cmfortable while appearing for real test, as you have been practicing on the same type of environment only.

There are many features ranging from study tips to how tos. I especially liked study notes and flash cards which will help each of us to recall the concepts so quickly especially when you are not in mood to read through the bulky notes or lengthy web articles :), I also found them useful while you want to quiz your ASP.NET 2.0 knowledge.

Ucertify's .NET 2.0 Web Application preparation kit will suffice all you need to learn about ASP.NET 2.0 exam objectives and really qualify the test.