如何在Sql Query的值前放置任何符号 [英] How to put any sign before value of Sql Query

问题描述

大家好，

我想使用我的SQL查询获取金额，但我想用+号显示该值

如何将其放在我的sql查询之前..

对于Exa:-

我得到的金额= 20000

但我想看起来像= +20000


谢谢问候

Hello to all,

I want to get amount using my sql query but i want to display that value with + sign

How can i put that before my sql query..

For Exa:-

Amount i Get that = 20000

But i want to look like = +20000


Thanks Regards

推荐答案

只需查看一下，然后试着理解.. :)

Just look into it, and try to understand.. :)

DECLARE @intVariable INT,@varcharVariable varchar(10)

--For interger variable 

SET @intVariable =2000
select '+'+convert(varchar,@intVariable) as Number

--For varchar variable

set @varcharVariable='2000' 
select '+'+@varcharVariable as Number

从表中可以像这样检索它::)

from table you can retrieve it like that... :)

select '+'+convert(varchar,amount) from TableName

这篇关于如何在Sql Query的值前放置任何符号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！