create table #test
(
aa money
)
declare @a varchar(100)
set @a='12.123'
insert into #test select cast(@a as money)
(
aa money
)
declare @a varchar(100)
set @a='12.123'
insert into #test select cast(@a as money)
@test:nvarchar(100)类型,用户插入
insert into tablename([money]) values(convert(money,@test))--orinsert into tablename([money]) values(cast(@test as money))
sql="insert kz(pro_money) values('"& pro_money &"')"
这种写法通不过,程序用asp写的,是不是有问题?
sql="insert kz(pro_money) values(convert(money,'"&pro_money&"'))"