SQL的截取 - MS-SQL Server / 基础类
数据库中price（列）是 ：123600
现要弄成：12.40万 或者 12.30万
SQL code:
select ltrim(cast(price*10/10000/10.0 as dec(18,2)))+'万'
from tb
select 123600.0/10000
---------------------------------------
12.3600000
(1 行受影响)
SQL code:
select ltrim(cast(round(price/10000.0,1) as dec(18,2)))+'万' as price from [tb]
SQL code:
select ltrim(cast(round(price/10000.0,1) as dec(18,2)))+'万' as price from tb
SQL code:
ltrim(cast(round(price/10000.0,2) as dec(18,2))) as price
相关问答：
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
sql的软件在哪里可以下啊！在网上找了蛮多都用不了啊
随便搞一D版吧，
迅雷第一个就可以用
2000,2005都这样
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
id url rank ......
下面是XML初始文件内容
XML code:
<upd:Update xmlns:lar="http://schemas.microsoft.com/msus/2002/12/LogicalApplicabilityRules" xmlns:cmd="http://schemas.microsoft.com/msus/2002/12/Up ......
