神马品牌网广西现任正副主席:存储过程？
来源：百度文库 编辑：神马品牌网 时间：2024/04/20 09:32:55
if exists(select name from sysobjects where name='kf_1' and type='p' )
CREATE PROCEDURE kf_1
AS
select * into zhou_1 from tb_newtell where client_kf in('yj077')
delete from tb_newtell where client_phone in(select * from zhou_1)
insert tb_resource select * from zhou_1
GO
检查语法是，报错再procedure附近有错误，请各位高手指点
CREATE PROCEDURE kf_1
AS
select * into zhou_1 from tb_newtell where client_kf in('yj077')
delete from tb_newtell where client_phone in(select * from zhou_1)
insert tb_resource select * from zhou_1
GO
检查语法是，报错再procedure附近有错误，请各位高手指点