so it means either i have to use "default" or identity?but if it dont need default or identity so wat else i can do?..please keep suggesting,,,i m trying hard to...

Hi mister.magoo,

Please tell me more about CTE..I am new to it and if possible give with an simple example how does it help and what is use of it?

okay....i try this..thanks for replying

is there no way to do alter???....is is bug in sql server?"

thanks a lot Lowell..it was great help...when will i have this much of brain 🙂

yes , right but here i got another problem..i m not able to insert data in this table

create table testj(

id int identity (1,500000000))

i tried these statments but got the...

If i add case and change M to F and F to M ...loop will not terminate...if i first convert m to f and back f to m will create...