1,SELECT *,CASE OrderStatus WHEN 1 THEN '未处理' when 2 THEN '锁定' when
3 THEN '已出票' ELSE '过期' END
from dbo.T_OrderItem
2,
SELECT *,CAST(ROUND(CAST (HostWin AS FLOAT)/(HostWin+HostDraw+HostBear),2)*100 AS varchar)+'%' AS HostWinRate,
CAST(ROUND(CAST (HostDraw AS FLOAT)/(HostWin+HostDraw+HostBear),2)*100 AS varchar)+'%'AS HostDrawRate,
CAST(ROUND(CAST (HostBear AS FLOAT)/(HostWin+HostDraw+HostBear),2)*100 AS varchar)+'%' AS HostBearRate from V_DoubleBuy
?Convert.ToDateTime(row.ItemArray[0])
--------------------------------查询系统库中是否有库（有库就删除此库）----------------------------------------------------
use master
if exists(select * from databases where name='库名')
drop database 库名
__________________________ 建数据库建表的基本格式 __________________ ......
UpSert功能：
MERGE <hint> INTO <table_name>
USING <table_view_or_query>
ON (<condition>)
WHEN MATCHED THEN <update_clause>
WHEN NOT MATCHED THEN <insert_clause>;
MultiTable Inserts功能：
Multitable inserts allow a single INSERT INTO .. SELECT statement to ......
