中科新闻网fit的过去式和过去分词:存储过程？
来源：百度文库 编辑：中科新闻网 时间：2024/05/09 05:52:13
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附近有错误，请各位高手指点