I want to change Code field varchar datatype to int ..is it possible through query,,?????
I tried with following query...showing error like .This key is acessed by other keys
ALTER TABLE [@VEDA_ALMD] ALTER COLUMN Code int
Actually my requirement is i want to generate serial no for code field but it is type of varchar due to this reason ...
records not getting inserted into proper position.(suppose i inserted 9 records. 10 record should insert at last but due to this varchar 10 record is inserting 2nd position this is making problem while pressing last rec,firstrec elc...)
im not at all getting last record properly........
is der any alternative.............????///