snoto10

孙卫强的记事本本人写的一个多页的记事本编程时记一些乱七八糟的东西增加页面就在标签页加一行保存更新一下就好了.很实用

SELECT EMPLOYEE.E031, [32重名表].Expr1, EMPLOYEE.E002, SPOUSE.S002, 
      EMPLOYEE.E063, EMPLOYEE.E005
FROM EMPLOYEE LEFT OUTER JOIN
      SPOUSE ON EMPLOYEE.E001 = SPOUSE.S001 RIGHT OUTER JOIN
      [32重名表] ON EMPLOYEE.E002 = [32重名表].Expr1
WHERE (EMPLOYEE.E031 = '00032') AND (EMPLOYEE.E063 = '1')
ORDER BY [32重名表].Expr1
找重名

SELECT NEXUS1.*
INTO s_nexus1
FROM NEXUS1 INNER JOIN
      EMPLOYEE ON NEXUS1.E001 = EMPLOYEE.E001
WHERE (EMPLOYEE.E031 = '00010')

SELECT NEXUS4.*
INTO s_nexus4
FROM NEXUS4 INNER JOIN
      EMPLOYEE ON NEXUS4.E001 = EMPLOYEE.E001
WHERE (EMPLOYEE.E031 = '00010')

SELECT NEXUS5.*
INTO s_nexus5
FROM NEXUS5 INNER JOIN
      EMPLOYEE ON NEXUS5.E001 = EMPLOYEE.E001
WHERE (EMPLOYEE.E031 = '00010')



SELECT SUBSTRING(lyxxb.mc, 5, 7) AS 楼号, SUBSTRING(zfxxb.zfbh, 6, 5) AS 房号, 
      dwxxb.dwmc AS 单位, zfxxb.xm AS 姓名, zfxxb.area AS 面积, zfxxb.cost AS 房价款, 
      zfxxb.wxjj AS 维修基金, zfxxb.tgjj AS 公积金, zfxxb.ttyt AS 红票, zfxxb.yfk AS 预付款, 
      zfxxb.dke AS 代款, zfxxb.bcyjk AS 本次
FROM zfxxb LEFT OUTER JOIN
      lyxxb ON zfxxb.lybh = lyxxb.lybh LEFT OUTER JOIN
      dwxxb ON zfxxb.dwbh = dwxxb.dwbh
WHERE (zfxxb.zfbh LIKE '001%') AND (zfxxb.gzrz = '己入住')
ORDER BY zfxxb.dwbh

SELECT SUBSTRING(lyxxb.mc, 5, 7) AS 楼号, SUBSTRING(zfxxb.zfbh, 6, 5) AS 房号, 
      zfxxb.dwmc AS 单位, zfxxb.xm AS 姓名, zfxxb.area AS 面积, zfxxb.cost AS 房价款, 
      zfxxb.wxjj AS 维修基金, zfxxb.tgjj AS 公积金, zfxxb.ttyt AS 红票, zfxxb.yfk AS 预付款, 
      zfxxb.dke AS 代款, zfxxb.bcyjk AS 本次, zfxxb.bck AS 补偿款, zfxxb.scsfk AS 首次, 
      zfxxb.ycfq AS 付清, zfxxb.yxds AS 电视
FROM zfxxb LEFT OUTER JOIN
      lyxxb ON zfxxb.lybh = lyxxb.lybh
WHERE (zfxxb.zfbh LIKE '001%')
ORDER BY zfxxb.zfbh


USE pubs
SELECT DISTINCT pub_name
FROM publishers
WHERE EXISTS
   (SELECT *
   FROM titles
   WHERE pub_id = publishers.pub_id
   AND type = 'business')

-- Or
USE pubs
SELECT distinct pub_name
FROM publishers
WHERE pub_id IN
   (SELECT pub_id
   FROM titles
   WHERE type = 'business')



select @ny= sccx from sys
if cast(@ny as integer)< cast(@nf+@yf as integer) 
begin
  insert into   fgcxb  select * from fgqfb where nf=@nf and yf=@yf --加冲消
  delete fgysb where nf=@nf and yf=@yf  --删予收

  insert into fgqfb (bh,fwbh,zgbh,nf,yf,dwbh,blbj)
  select fwbh+@nf+@yf as bh,fwbh,zgbh,@nf as nf,@yf as yf,@dwbh as dwbh ,'0000' as blbj 
  from fwxxb 
  where (byjf='N')and (ifdel=0)    
  
  update fwxxb set byjf='N' where (ifdel=0) --变为都未交 
  update sys set sccx=@nf+@yf
  set @ret=0 
end
else
set @ret=1


{  s_sql:='INSERT INTO fgysb (bh, fwbh, zgbh, nf, yf, je, dwbh, blbj) '+
         'SELECT fwxxb.fwbh + '''kfny' AS bh, fwxxb.fwbh, fwxxb.zgbh, '''+nf+
         ''' AS nf, '''+yf+''' AS yf, '+
         'fwxxb.gdff - fwxxb.jmje AS je, '''+dwbh+''' as dwbh, '1000' AS blbj  '+
         'FROM fwxxb INNER JOIN '
         ' zgxxb ON fwxxb.zgbh = zgxxb.zgbh '
         ' WHERE (zgxxb.dwbh = '''+dbdw.KeyValue ''') ' ;
 }






GO