在线求一存储过程

[monkeys]

我传一参数给存储过程，
存储过程得到参数后先去table2判断是否存在该值,
如果该值在table2中存在,则不对Table1/Table3/Table4进行操作,
否则
将Table1/Table3/Table4中存在该值的数据删除


最后返回一值,如果是1 表示删除成功,0表示错误

[okoko]

create proc p_table2 @sign varchar(2)='1'
as
begin
if @sign='1'
select ...
else
select ....
end;

[okoko]

create proc p_table2 @fieldname varchar(30)=''
as
begin
if not exists (select 1 from table2 where fieldname=@fieldname)
delete from Table1(/Table3/Table4) where fieldname=@fieldname
end;

[zheninchangjiang]

create procedure d_test
@value varchar(100),@flag int output
as
if not exists(select 1 from table2 where col1=@value)
begin
begin transaction
delete table1 where col1=@value
if @@error>0
goto errhand
delete table3 where col1=@value
if @@error>0
goto errhand
delete table4 where col1=@value
if @@error>0
goto errhand
commit transaction
set @flag=1
end

errhand:
begin
rollback
set @flag=0
end

[okoko]

好，有错处理。（楼上的）

[leiyu1112]

在数据库中创建存储过程：
CREATE PROC prcListContractractRecruiter @cCity char(15)
(@cCity char(15)变量名)
AS
BEGIN
PRINT 'Kist of Contract Recruiters'
select cName,cCity,cZip,cPhone From ContractRecruiter WHERE cCity = @cCity
end
1。执行
F5

2。然后检查数据库中过程的存在
sp_helptext prcListContractRecruiter

3. 执行哟寸在值的过程
prcListContractrecruiter Alexandria

4。执行有不存在值的过程
prcListContractrecruiter Boston