求一sql语句!

将一组数据sj插入数据库A字段，保留两位小数。如何实现？

[28 byte] By [ngzh0811] at [2008-1-6]

# 1

insert table1(a) values select sj from table2

# 2

ding

# 3

select sj from table2
什么意思？

ngzh0811 at 2007-10-25 >

# 4

你是不是数据放在两表?

# 5

insert into dbname..tablename(a)
select ROUND(sj,2) from tablename

insert into dbname..tablename(a)
select cast(sj as numeric(18,2)) from tablename

# 6

不是两个表，数据是固定的数值。

ngzh0811 at 2007-10-25 >

# 7

那就把数据先做成一个表

# 8

那就直接select数值就行

insert into dbname..tablename(a)
select ROUND(sj,2)

insert into dbname..tablename(a)
select cast(sj as numeric(18,2))

MS-SQL Server Hot Topic