Hi,

You can assume anything.Though structure of my table is

CREATE TABLE [emp] (

[empid] [int] IDENTITY (1, 1) NOT NULL ,

[Fname] [varchar] (100) NOT NULL ,

[Lname] [varchar] (100) NOT NULL

) ON [PRIMARY]

GO