asp.txt

系统后台表创建方式 系统后台表创建方式 系统后台表创建方式

sa2008-6-24 13:44:351  1 20 '20080626'

select distinct 2,Folder.name,item.name,1,'0000',Folder.type
		from FolderRelation,Folder,item
		where FolderRelation.PID='sa2008-6-24 13:44:351' and FolderRelation.CID=Folder.ID and folder.name = item.id and Folder.type<>'1'


select 1,FolderRelation.CID,Folder.name,1,'0000',Folder.type
		from FolderRelation,Folder
		where FolderRelation.PID='sa2008-6-24 13:44:351' and FolderRelation.CID=Folder.ID and Folder.type='1'

select 4,document.id,document.name,1,'0000',Folder.type
		from FolderRelation,Folder,document
		where FolderRelation.PID='sa2008-6-24 13:44:351' and FolderRelation.CID=Folder.ID and  Folder.ID=document.id and Folder.type='4'
////////////////////////////////////////////////////

  SELECT t_publicrecord.barbm,   
         t_publicrecord.bkrecd,   
         t_publicrecord.librq,   
         t_publicrecord.address,   
         t_publicrecord.ltype,   
         t_publicrecord.remark,   
         t_publicrecord.gox,   
         t_publicrecord.autherbm,   
         t_publicrecord.jcrq,   
         t_publicrecord.jctm,   
         t_publicrecord.yhrq,   
         t_publicrecord.signal,   
         t_publicrecord.xjtms,   
         t_publicrecord.ljtms,   
         t_publicrecord.ljdt,   
         t_publicrecord.eprice,   
         t_publicrecord.price,   
         t_publicrecord.zzsignal,   
         t_publicrecord.cfjlbm,   
         t_publicrecord.fzc,   
         t_publicrecord.fz,   
         t_publicrecord.qkjq,   
         t_book.indxnb,   
         t_book.name,   
         t_reader.bm,   
         t_reader.name  
 FROM    
         t_publicrecord 
         left  outer join t_book on  ( t_book.id = t_publicrecord.bkrecd )  
         left  outer join t_reader  on ( t_publicrecord.autherbm = t_reader.id) 

SELECT t_processlog.process, t_processlog.bkid, t_book.name,t_book.ISBN,t_book.pbldate,t_book.author,t_processlog.admintm,sum(bkbm) as 'c8'
FROM t_processlog  left outer join t_book 
on (t_processlog.bkid = t_book.id)
 WHERE ((t_processlog.bkid <>'') AND ( process ='借出')) 
group by t_processlog.process, t_processlog.bkid, t_book.name,t_book.ISBN,t_book.pbldate,t_book.author,t_processlog.admintm
;

select  bkid,name,ISBN,pbldate,author,sum(c8)as 'zs' from view_phsort
group by bkid,name,ISBN,pbldate,author
order by zs desc;

select top 10 bkid,name,ISBN,pbldate,author,sum(c8)as 'zs' from view_phsort
 where admintm>='20080608' and admintm<='20080715'
group by bkid,name,ISBN,pbldate,author
order by zs desc;
select bm,name,ltype,unit,sum(c8)as "zs" from  view_rdphsort where 
SELECT      dbo.t_reader.bm, dbo.t_reader.name, dbo.t_reader.ltype, dbo.t_reader.unit,  dbo.t_processlog.admintm, COUNT(dbo.t_processlog.rdbm) AS 'c8', dbo.t_book.price
FROM         dbo.t_processlog LEFT OUTER JOIN
                      dbo.t_reader ON dbo.t_processlog.rdbm = dbo.t_reader.bm
WHERE     (dbo.t_processlog.rdbm <> '') AND (dbo.t_processlog.process = '借出')
GROUP BY  dbo.t_reader.bm, dbo.t_reader.name, dbo.t_reader.ltype, dbo.t_reader.unit,  dbo.t_processlog.admintm