写个存储过程: CREATE PROCEDURE DEL_DATA @fd varchar(20) AS declare @idx int declare @row_count int select @row_count=count(*) from tbl_all set @idx=1 while @idx<@row_count begin declare @tbl varchar(20) select @tbl=tbl from tbl_all where idx=@idx delete from @tbl where fd_test=@fd set @idx=@idx+1 end GO