问句SQL，很麻烦
SQL code:
select xz_staffname,xz_clientname,case
when XZ_OutStockDate >= '2006-12-26' and XZ_OutStockDate <= '2007-12-25' then 2007
when XZ_OutStockDate >= '2007-12-26' and XZ_OutStockDate <= '2008-12-25' then 2008
when XZ_OutStockDate >= '2008-12-26' and XZ_OutStockDate <= '2009-12-25' then 2009
when XZ_OutStockDate >= '2009-12-26' and XZ_OutStockDate <= '2010-12-25' then 2010
when XZ_OutStockDate >= '2010-12-26' and XZ_OutStockDate <= '2011-12-25' then 2011
end as myear,m1m=sum(case
when XZ_OutStockDate >='2008-12-26' and XZ_OutStockDate<='2009-1-25'
then moneys end) ,m2m=sum(case
when XZ_OutStockDate >= '2009-1-26' and XZ_OutStockDate<='2009-2-25'
then moneys end) ,m3m=sum(case
when XZ_OutStockDate >= '2009-2-26' and XZ_OutStockDate<='2009-3-25'
then moneys end) ,m4m=sum(case
when XZ_OutStockDate >= '2009-3-26' and XZ_OutStockDate<='2009-4-25'
then moneys end) ,m5m=sum(case
when XZ_OutStockDate >= '2009-4-26' and XZ_OutStockDate<='2009-5-25'
then moneys end) ,m6m=sum(case
when XZ_OutStockDate >= '2009-5-26' and XZ_OutStockDate<='2009-6-25'
then moneys end) ,m7m=sum(case
when XZ_OutStockDate >= '2009-6-26' and XZ_OutStockDate<='2009-7-25'
then moneys end) ,m8m=sum(case
when XZ_OutStockDate >= '2009-7-26' and XZ_OutStockDate<='2009-8-2
相关问答：
sql table表有个文本类型的a字段，存储的内容全部是数字，例如2009001，2008578这样的格式；b字段文本类型，存的也是数字例如 001，123
asp里面 strday=100，strb=001
我想读出，从a字段的数字按大到小的� ......
小弟是个新手 现在有个问题一直不能解决
例如
procedure produce_proc
@p001 nvarchar(8000),
@p002 nvarchar(8000),
@p003 nvarchar(8000),
& ......
PHP code:
将数据库中的proc都执行一遍
不会是 EXEC sp_MSforeachtable？肯定不是啦，是什么呢？
這個不太現實吧,有的有參數有的沒有怎麼辦?
如果� ......
在建立与服务器的连接时出错。在连接到 SQL Server 2005 时，在默认的设置下 SQL Server 不允许进行远程连接可能会导致此失败。 (provider: SQL 网络接口, error: 26 - 定位指定的服务器/实例时出错)
== ......
