比比谁的单条SQL语句最长。先看我的：

Question

我的用了5K的buffer来装
计算空格 3561

Answer 1

有瘾呐，写这么长，我把整个‘UNIT’中的代码，贴到query.sql中行不行？

Answer 2

select 嵌套了 n个case 关联了6个表
  能不长吗?

Answer 3

原来如彼，在下真是孤陋寡闻，见谅！
999999999999999999999999999999999999999999999999999
999999999999999999999999999999999999999999999999999
99999999999B@B@B@BBBMMMM999999999999999999999999999
999999999999M+:.:+9999M:999999999999999999999999999
9999999999999MM9+99MMM:9999999999999999999999999999
99999999999999M+.+99M:99999999999999999999999999999
99999999999999B:.++9M:99999999999999999999999999999
99999999999999B+.+99M:9999AAAAAA9999999999999999999
99999999999999B:.++9M:9AAA++++:+AAA9999999999999999
99999999999999B+.+99M:A+9+A:+++++9AA999999999999999
99999999999999B:.++9:A+@+A:,:++9+A9@M99999999999999
99999999999999B+.+9:A+A,,,,,,+A+A9@A@M9999999999999
99999999999999B:.++A+A+,,.,,+A9A9@A@M@M999999999999
99999999999999B+.+9AA+,,...,++A9@A@A@MM999999999999
99999999999999B:.+:A+++,,.,,++9@A@A@M@M999999999999
99999999999999B+.+A+@+,,,,,+9A@A+@@M@M@M99999999999
99999999999999B:.+A@+++,+,+9A9A++@M@M@MM99999999999
99999999999999B+.+A+@++++++A9A++9M@M@M@M99999999999
99999999999999B:.+A@+@+:+9A9A9A9M@M@M@9M99999999999
0A999999999999B+.+A+@+@+@+@+@A@A@9@9@9@M99999999999
99999999999999B:.+A@+@+@+@+@+@A@M@9@9@9M99999999999
99999999999999B+.+:A@+@+@+@+@A@M@9@9@9M999999999999
99999999999999B:.+:A9@+@+@+@9@A@M@9@9@M999999999999
99999999993333333333M9@9@9@9@9@M@9@9@9M999999999999
99999999993.........MAA99@9@9@M@9@9@9M9999999999999
99999999993...MMMM..MM@9@9@9@9@M@9@9M99999999999999
99999999993....MMM..M:M@9@9@9@9@9@9M999999999999999
99999999993...MMMM..M:9MMM@9@9@9MMM9999999999999999
99999999993..MMM.M..M:9999MMMMMM9999999999999999999
99999999993..MM.....M:99999999999999999999999999999
99999999993..M......M:99999999999999999999999999999
99999999993...M.....MM:9999999999999999999999999999
99999999993.........M9M:999999999999999999999999999
9999999999MMMMMMMMMMMMMM:99999999999999999999999999
999999999999999999999999999999999999999999999999999
999999999999999999999999999999999999999999999999999
999999999999999999999999999999999999999999999999999
999999999999999999999999999999999999999999999999999
999999999999999999999999999999999999999999999999999
999999999999999999999999999999999999999999999999999
99999999999999999999.9999999.9999999999999999999999
9999999....999999999.9999999.99999.999999..99999999
9999999.999.99999999.9999999.99999999999.9999999999
9999999.9999.99...99.9....99....99.9999.99999999999
9999999.9999.9.999.9.9.999.9.999.9.9999....99999999
9999999.9999.9.....9.9.999.9.999.9.9999.999.9999999
9999999.9999.9.99999.9.999.9.999.9.9999.999.9999999
9999999.999.99.999.9.9.999.9.999.9.9999.999.9999999
9999999....9999...99.9....99.999.9.99999...99999999
9999999999999999999999.9999999999999999999999999999
9999999999999999999999.9999999999999999999999999999
999999999999999999999999999999999999999999999999999
999999999999999999999999999999999999999999999999999
999999999999999999999999999999999999999999999999999
999999999999999999999999999999999999999999999999999
999999999999999999999999999999999999999999999999999
999999999999999999999999999999999999999999999999999
9999999999999999999999999999999999999999999999999990

Answer 4

这是我写的一个存储过程，但是可能不怎么长。Create Procedure CondDayRep
  @TDate Datetime,@Team varchar(3)
As
Declare @FromDay Datetime
Select @FromDay=@TDate
While Day(@FromDay)<>26
   Select @FromDay=@FromDay-1Select TicNo,CName,RComein,TicNumbers,MonRComein,MonTicNumbers From
(
 Select F.TicNo,RComein,TicNumbers,MonRComein,MonTicNumbers From
 (
   Select A.TicNo,RComein,TicNumbers From
      (Select TicNo,IsNull(Comein2,0)-IsNull(Other,0) RComein From Trans2
       Where TDate=@TDate and
       Route In (Select Route From Routes Where Team=@Team)
      ) A
   join 
      (Select TicNo,Sum(IsNull(TNumber,0)) TicNumbers From Trans2
      Join Comeint on TId=TNo 
      Where TDate=@TDate and
      Route In (Select Route From Routes Where Team=@Team)
      Group by TicNo
      ) B 
   on A.TicNo=B.TicNo
 ) E Right Join
 (
   Select C.TicNo,MonRComein,MonTicNumbers From
      (Select TicNo,Sum(IsNull(Comein2,0)-IsNull(Other,0)) MonRComein  From Trans2
      Where (TDate  between @FromDay and @TDate) and
      Route In (Select Route From Routes Where Team=@Team)
      Group by TicNo
      ) C
   Join 
      (Select TicNo,Sum(IsNull(TNumber,0)) MonTicNumbers From Trans2
      Join Comeint on TId=TNo 
      Where (TDate between @FromDay and @TDate) and
      Route In (Select Route From Routes Where Team=@Team)
      Group by TicNo
      ) D
   on  C.TicNo=D.TicNo
 ) F On E.TicNo=F.TicNo
) G,Conductors Where TicNo=CNo

Answer 5

我也写过一句Select,  结果说字符超长不能执行， 又有一次说打开过多的数据表

Answer 6

(广州）精通数据库编程，熟悉INTERNET编程，熟悉SQL-SERVER，至少一年DELPHI编程经验，有独立负责开发项目能力，我公司将为您提供良好的个人发展空间，有意者请先将个人简历及其他相关资料和个人要求等说明EMAIL至以下地址（请不要使用附件） 
联系人：刘先生 
EMAIL：[email protected]