34,837
社区成员




--4、
select dh,bml from yhdang where bml like '一局%'
--1、
insert into hdmx(Dh,Hssj,Thsc,Zjjx) select Dh,Hssj,Thsc,Zjjx from [hdmx200605]
--2、
select * from T1 a where not exists(select 1 from t2 where yhmc=a.yhmc)
--3、
if not exists(select 1 from hthhf where hf>0)
begin
drop table hthhf
end
--4、
update yhdang set hfadd=b.hfhjs from yhdang a,
(select dh,sum(hfhj)hfhjs from [hdmx200605] group by dh) b
where a.dh=b.dh
--5、
insert into tel_new..yhdang select * from tel_old..yhdang
--6、
select top 0 * into yhdang_tmp from yhdang
--7、
存储过程中看不到黑体字。。
Hth,
Hth,Dh,
Hth,Dh,Yhmc,
Hth,Dh,Yhmc,Yhdz,
Hth,Dh,Yhmc,Yhdz,
th,Dh,Yhmc,Yhdz,
SELECT dh,bml FROM Yhdang WHERE Bml LIKE '一局%'
SELECT dh,bml FROM Yhdang WHERE CHARINDEX('一局',Bml)=0
...
INSERT Hdmx(dh,hssj,thsc,zjjx) SELECT dh,hssj,thsc,zjjx FROM hdmx200605
SELECT a.* FROM t1 a WHERE NOT EXISTS(SELECT 1 FROM t2 WHERE yhmc=a.yhmc)
SELECT a.* FROM t1 WHERE 1>(SELECT COUNT(*) FROM t2 WHERE yhmc=a.yhmc)
SELECT a.* FROM t1 WHERE yhmc NOT IN(SELECT yhmc FROM t2)
SELECT a.* FROM t1 a LEFT JOIN t2 b ON a.yhmc=b.yhmc WHERE b.yhmc IS NULL
...
IF object_id('hthff') IS NOT NULL
BEGIN
IF NOT EXISTS(SELECT 1 FROM hthhf WHERE hf>0)
DROP TABLE hthhf
END
..
UPDATE a SET HfAdd = sHfhj
FROM Yhdang a
INNER JOIN
(SELECT dh,SUM(hfhj) sHfhj FROM hdmx200605 GROUP BY dh) b
ON a.dh=b.dh
INSERT tel_new..yhdang SELECT * /*or fields list*/ FROM tel_old..yhdang
--openrowset
--opendatasource...
--openquery...
SELECT * FROM yhdang_tmp FROM yhdang WHERE 1=0
7,存储过程不答了。
select Hth,Dh,Yhmc,Yhdz
elect Hth,Dh,Yhmc,Yhdz
select dh, bml
from Yhdang
where Bml like '一局%'
insert into Hdmx
select Dh, Hssj, Thsc, Zjjx
from Hdmx200605
select *
from T1
where not exists (select 1 from T2 where T2.Yhmc=T1.Yhmc)
if not exists (select 1 from Hthhf where hf>0)
drop table Hthhf
update Yhdang set
HfAdd = b.Hfhj
from Yhdang a
join (select Dh, Hfhj=sum(Hfhj) from Hdmx200605 group by Dh) b on a.Dh=b.Dh
select dh,bml from Yhdang where Bml like N'一局%'
insert into Hdmx (Dh,Hssj,Thsc,Zjjx)
select Dh,Hssj,Thsc,Zjjx
from Hdmx200605
select * from T1 where Yhmc not in (select Yhmc from T2)
if not exists ( select * from Hthhf where hf> 0)
drop table Hthhf
update Yhdang set HfAdd = sum(T2.Hfhj)
from Yhdang T1
JOIN Hdmx200605 T2 ON T1.Dh=T2.Dh
GROUP BY T2.Dh
INSERT INTO [Tel_New]..Yhdang select * from [Tel_Old]..Yhdang
select * into Yhdang_tmp from Yhdang where 1=0