Thanks for the idea vishkk47.

But it was giving me wierd error "An explicit value for the identity column in table 'emp' can only be specified when a column list...