经典SQL语句
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 库名
__________________________ 建数据库建表的基本格式 __________________ ......
SQL的优化应该从
5
个方面进行调整：
1.去掉不必要的大型表的全表扫描
2.缓存小型表的全表扫描
3.检验优化索引的使用
4.检验优化的连接技术
5.尽可能减少执行计划的
Cost
SQL语句：
是对数据库(
数据
)
进行操作的惟一途径；
消耗了70%~90%
的数据库资源；独立于程序设计逻辑，相对于对程序源代码的优化， ......
I'm continually trying to track down what service packs are installed on various SQL Servers I support. I can never find the right support page on Microsoft's site. So here's an article with all the SQL Server version information I can track down. If you know of any older versions or can help me fil ......
本文主要内容属转载，但笔者根据该文内容测试成功，故分享于此。
笔者实验环境：Windows Server 2003 Enterprise Edition。
先给出原文链接，稍后调整。
原文链接为：http://www.shilai.cn/2007/5/6/problems-of-installing-sql2005.aspx ......
create function fun_getPY(@str nvarchar(4000))
returns nvarchar(4000)
as
begin
declare @word nchar(1),@PY nvarchar(4000)
set @PY=''
while len(@str)>0
begin
set @word=left(@str,1)
--如果非汉字字符，返回原字符
set @PY=@PY+(case when unicode(@word) between 19968 and 19968+20901
......
