DECLARE
@Quantity nvarchar(2),
@UnitPrice nvarchar(8),
@Total int
set @Quantity='2'
set @UnitPrice='6'
set @Total=convert(int,@Quantity)*convert(int,@UnitPrice)
print @Total
@Quantity nvarchar(2),
@UnitPrice nvarchar(8),
@Total int
set @Quantity='2'
set @UnitPrice='6'
set @Total=convert(int,@Quantity)*convert(int,@UnitPrice)
print @Total
@Quantity varchar(2),
@UnitPrice varchar(8),
@Total varchar(4)
set @Quantity='2'
set @UnitPrice='6'
set @Total= convert(int,@Quantity)*convert(int,@UnitPrice)
print @Total
@Quantity nvarchar(2),
@UnitPrice nvarchar(8),
@Total int ----(4)这个不用加
set @Quantity='2'
set @UnitPrice='6'
set @Total=convert(int,@Quantity)*convert(int,@UnitPrice)
print @Total