This is very interesting & powerful query provided by SQL Server 2008, using this query we can add/update/delete multiple records in a table using single query without creating multiple insert/update/delete queries.

1) We can also achive same functionality in SQL 2005 to as,Suppose we are having addresses table which contains multiple addresses for employee then we can make