用存储过程将A.B2个表里某一个列(例如:电话号码) 对比,如果A表的号码,B表有则去掉

来源：百度知道 编辑：UC知道 时间：2024/06/07 21:51:00
A表有个字段电话号码
B表有个字段电话号码
存储过程:
A表与B表对比,A表中有的号码,B表中不能重复,如有重复,B表里删除

如:
A:电话号码有个654555
查询B里电话号码有654555,则B表里删除此行数据

delete from B where telno in(
select telno from A )

楼上的说的delete from B where telno in(
select telno from A ) 只是SQL语句，不是存储过程。你参考下面写吧。
http://cache.baidu.com/c?word=%B4%E6%B4%A2%3B%B9%FD%B3%CC&url=http%3A//blog%2Esina%2Ecom%2Ecn/s/print%5F40449dd101000asp%2Ehtml&p=9765c54ad6c116fc57eeca3b554b&user=baidu

CREATE OR REPLACE PROCEDURE NBIS_SCD_0708.TESTPROCEDURES AS
BEGIN
delete from B where telno in(
select telno from A );
END;

sqlserver数据库
create proc procName
as
begin

delete from B where telno in(
select telno from A );

end

oracle数据库
create or replace procedure 表空间.procName
as
begin
delete from B where telno in(
select telno fro