Skip to Content
0
Former Member
Sep 05, 2009 at 04:32 AM

How to chnage datatype of Code field of master data

22 Views

Hello,All

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.............????///

by

Firos