I the question you mention sales value of 150 for customerID 5. But in the answer you are inserting 25 for customerID. If anyone can help here?

Good explanation. Thanks

Subhash

If I got it wrong then please clarify following:

/* Please run following TSQL query */

CREATE DATABASE TESTING

GO

USE TESTING

GO

CREATE TABLE TESTING

(id INT,

CITY VARCHAR(40),

PIN VARCHAR(6)

)

GO

INSERT...

Hi Rahul,

I am just new to sql server. But I just want to know one simple question what will be the statement if i want to update a particular column...

I have tested this.

In context of SQL Server 2000 it is correct answer as by you.

But In SQL Server 2008 answer will be 1,2,3,4.

😛