求购世界上最长的一条SQL语句~暴笑优先
超人汪 2004-09-14 12:45:29 我自己写过最长的一句SQL是一个4表联查的语句,如下:
select t1.projectCode,pm.projectName,sum(t1.ratifyMoney)-sum(t1.loanAllMoney)-sum(t1.accountAllMoney)'canloanmoney'
,sum(t1.ratifyProduct)-sum(t1.loanAllProduct)-sum(t1.accountAllProduct)'canloanproduct' from
(select pm.projectCode'projectCode',pm.projectName'projectName',0'ratifyMoney',0 'ratifyProduct'
,0'loanAllMoney',0'loanAllProduct',0'accountAllMoney',0'accountAllProduct'
from TP_ProjectMaster as pm where ratifyStatusCode=3 and (executeStatusCode=0 or executeStatusCode=1)
union
select pd.projectCode'projectCode','projectName',ratifyMoney 'ratifyMoney',0 'ratifyProduct'
,0'loanAllMoney',0'loanAllProduct',0'accountAllMoney',0'accountAllProduct'
from TP_ProjectDetail as pd where ratifyPayModeCode='3'
union
select pd.projectCode'projectCode','projectName',0'ratifyMoney',ratifyMoney'ratifyProduct'
,0'loanAllMoney',0'loanAllProduct',0'accountAllMoney',0'accountAllProduct'
from TP_ProjectDetail as pd where ratifyPayModeCode='2'
union
select lm.projectCode'projectCode','projectName',0'ratifyMoney',0'ratifyProduct'
,loanAllMoney'loanAllMoney',0'loanAllProduct',0'accountAllMoney',0'accountAllProduct'
from TL_LoanMaster as lm where loanType = 3 and ratifyStatusCode<>2 and (executeStatusCode=0 or executeStatusCode=1)
union
select lm.projectCode'projectCode','projectName',0'ratifyMoney',0'ratifyProduct'
,0'loanAllMoney',loanAllMoney'loanAllProduct',0'accountAllMoney',0'accountAllProduct'
from TL_LoanMaster as lm where loanType = 2 and ratifyStatusCode<>2 and (executeStatusCode=0 or executeStatusCode=1)
union
select am.projectCode'projectCode','projectName',0'ratifyMoney',0'ratifyProduct'
,0'loanAllMoney',0'loanAllProduct',accountAllMoney'accountAllMoney',0'accountAllProduct'
from TA_AccountMaster as am where accountKind=0 and accountType=3 and ratifyStatusCode<>2 and (executeStatusCode=0 or executeStatusCode=1)
union
select am.projectCode'projectCode','projectName',0'ratifyMoney',0'ratifyProduct'
,0'loanAllMoney',0'loanAllProduct',0'accountAllMoney',accountAllMoney'accountAllProduct'
from TA_AccountMaster as am where accountKind=0 and accountType=2 and ratifyStatusCode<>2 and (executeStatusCode=0 or executeStatusCode=1)
) as t1,TP_ProjectMaster as pm
where t1.projectCode= pm.projectCode and pm.ratifyStatusCode = 3
and (t1.projectCode like '%'+@projectcode+'%' or pm.projectName like '%'+@projectcode+'%')
group by t1.projectCode,pm.projectName
having (sum(t1.ratifyMoney)-sum(t1.loanAllMoney)-sum(t1.accountAllMoney)>0 or sum(t1.ratifyProduct)-sum(t1.loanAllProduct)-sum(t1.accountAllProduct)>0)
order by t1.projectCode
这其实就只是一条Select语句,我统计了一下,字符数(不记空格)为2411个,(记空格)为2532个
以2个字符等于1个汉字的长度来算,这条SQL一共有1200多个字
请各位把你们看到过的最长最眩最夸张的SQL语句贴出来让大家开心开心!!
越长分越多哈!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!