I have always experienced and am convinced that, while learning a programming technique, it is more helpful to see an example that matches our specific requirement, rather than some theoretical stuff. Examples are really good for learning the basics and...

This article intends to help the beginners to get started with Transact SQL code that uses IF-ELSE logic....

This post explains the differences between TSQL functions CAST() and CONVERT(). Though they seem identical, there are several differences between these functions. ...

BULK INSERT is used to insert data to a table from a text file. Only problem with it is that it is not possible to specify the columns that you want data to be imported. For example the table has 4 columns whereas there are data for 2 columns in the text...

  XML Workshop - A series of XML articles published at www.sqlservercentral.com XML Workshop I - Generating XML with FOR XML - A short article that explains how to generate XML output with TSQL keyword FOR XML with AUTO and RAW directives XML Workshop...

If you put jQuery in your CV, then beware, you should be able to answer following questions. Better you read on, and test yourself how much you can score. 1. What is jQuery & its significance? Why it is so popular? 2. What is jQuery UI? 3. What are...

Microsoft Entity Framework version 4.0 is a brand new ORM(Object Relational Mapper) from Microsoft. It’s provides now some new features which are not there in the earlier version of Entity framework. Let’s walk through a simple example of...

The Microsoft® SQL Server® 2008 R2 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2008 R2. The following components are available for download as part of the Feature Pack. Microsoft® SQL...