＋设为首页 ＋添加到收藏夹
CREATE PROCEDURE [InsertMoney]
(
@GUID char(36),
@Amount float
)
AS
declare @strSQL nvarchar(1000)
select @strSQL = @strSQL + Update Test Set HaHaMoney = HaHaMoney + +str(@Amount)+ where GUID=+@GUID+
exec(@strSQL)
GO
HaHaMoney是float,可怎么加它都是整型？
CREATE PROCEDURE [InsertMoney]
(
@GUID char(36),
@Amount float
)
AS
declare @strSQL nvarchar(1000)
set @strSQL=
select @strSQL = @strSQL +
Update Test Set HaHaMoney = HaHaMoney + +str(@Amount)+ where GUID=+@GUID+
exec(@strSQL)
GO
没有参数的str默认小数位数0。
然后就成了整数了。
declare @a float
set @a = 1
select @a+2
-----------------------------------------------------
3.0
CREATE PROCEDURE [InsertMoney]
(
@GUID char(36),
@Amount float
)
AS
declare @strSQL nvarchar(1000)
set @strSQL=
select @strSQL = @strSQL +
Update Test Set HaHaMoney = HaHaMoney + +str(@Amount,10,4)+ where GUID=+@GUID+
exec(@strSQL)
GO
CREATE PROCEDURE [InsertMoney]
(
@GUID char(36),
@Amount float
)
AS
declare @strSQL nvarchar(1000)
set @strSQL=
select @strSQL = @strSQL + Update Test Set HaHaMoney = HaHaMoney + +str(@Amount,10,3)+ where GUID=+@GUID+
exec(@strSQL)
GO
