1。先导成char(10);
2。再在表中进行转换
alter tablename
add column colsi smallint
go
update tablename set colsi = cast(colch10 as smallint)
3。去掉colch10
alter tablename
drop column colch10
2。再在表中进行转换
alter tablename
add column colsi smallint
go
update tablename set colsi = cast(colch10 as smallint)
3。去掉colch10
alter tablename
drop column colch10
2、SELECT 列,cast(colch10 as smallint) colch10 into 新表 from 表
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="E:\Borland\Shared\Data\";User ID=Admin;Password=;Extended properties=dbase 5.0')...animals
animals.dbf 在 E:\Borland\Shared\Data\