高考问答99式伞兵刀是几号钢:存储过程？
来源：百度文库 编辑：高考问答 时间：2024/07/06 18:34:42
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附近有错误，请各位高手指点