代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/150090/12315076
sql s.sql
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES
(1,1,'RYID',0,'','String ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,
www.eeworm.com/read/150090/12315095
sql tdwxx.sql
INSERT INTO tDWXX
(DWID,DWDM,DWMC,ZZJGDM,SWDJDM,GSDJDM,BXDJDM,DWDZ,DWYB,CLRQ,CBRQ,SSHY,HYDM,ZGBMDM,ZGBMMC,JJLX,LSGX,DWXZ,
CZLB,DWZT,DQH,JSFS,YHHH,KHYH,ZHMC,YHZH,FRDB,FRDH,FRSFZ,CWFZR,CWDH,SBZGY,ZGY
www.eeworm.com/read/150090/12315105
sql calall.sql
declare
v_num integer;
begin
v_num:=2822; --起始数字
for rec in (
Select
rtrim(RYID) as "RYID_FF",
'185' as DWID_FF,
'1000000000' as "SSDWID",
r
www.eeworm.com/read/150090/12315110
sql 2.sql
select count(*) from tff_dwxx where sjdwdm='1000000000'
select * from tff_dwxx
where sjdwdm='1000000000' and khmc not like '%农行%' and khmc not like '%农业%'--137
and khmc not like '%工行%' and khmc n
www.eeworm.com/read/150090/12315112
sql 1.sql
Select
RYID as "RYID_FF",
ZH as DWID_FF,
'1000000000' as "SSDWID",
XM,
'123456789012345' as "SFZH",
ZS1 as "HDJE",
3 as FFFS,
'10000000000' as "FFJGID",
3 as DJQK,
c2 as DZ,
C3 as YZBM,
Z
www.eeworm.com/read/150090/12315116
sql 3.sql
select count(*) from tff_dwxx where sjdwdm='1000000000' --185
select count(*) from tff_dwxx where sjdwdm='1000000000' and khmc like '%农行%' or khmc like '%农业%'--137
--select count(*) from tff_dwxx wh
www.eeworm.com/read/150090/12315126
sql 树展开.sql
--显示行业节点
SELECT DMB.DMMC,COUNT(*) DMCOUNT
FROM tDMB DMB,tff_dwxx DW
WHERE DMB.DM(+)=DW.SSHY and DMB.ZDBZ='SSHY'
GROUP BY DMMC
ORDER BY DMMC
--显示单位节点
SELECT DW.SSDWID,DW2.DWMC,COUNT(*) D
www.eeworm.com/read/150063/12319327
sql trade.sql
www.eeworm.com/read/338182/12320636
sql 多行补充.sql
declare @t table(a int,b varchar(10),c int)
insert into @t
select 100,'x',32
union all select 100,'y',31
union all select 100,'z',42
union all select 201,'x',33
union all select 201,'y',43
unio
www.eeworm.com/read/150059/12321484