以下是一插入的存储过程.先插入数据.然后查询一下.如果插入成功返回大于0的值.
可却无法插入.但又不抱错误.都不知道错在哪了.请大家帮忙看看.谢谢.
if exists(select * from sysobjects where name = 'proc_addAppliers')
drop proc proc_addAppliersgo
create proc proc_addAppliers
@sum int output,@num varchar,
@name varchar,
@level int,
@date varchar,
@note varchar
asinsert into supplier (supplierNo,supplyGoodName,supplyGoodSafe,supplierActionTime,supplierNote)values(@num,@name,@level,@date,@note);select @sum =count(*)from supplier where supplierNo =@num
declare @end int
exec proc_checkLoad @end output,3,orb,3,2008-9-6,备注
if @end >0
print 'ok'
可却无法插入.但又不抱错误.都不知道错在哪了.请大家帮忙看看.谢谢.
if exists(select * from sysobjects where name = 'proc_addAppliers')
drop proc proc_addAppliersgo
create proc proc_addAppliers
@sum int output,@num varchar,
@name varchar,
@level int,
@date varchar,
@note varchar
asinsert into supplier (supplierNo,supplyGoodName,supplyGoodSafe,supplierActionTime,supplierNote)values(@num,@name,@level,@date,@note);select @sum =count(*)from supplier where supplierNo =@num
declare @end int
exec proc_checkLoad @end output,3,orb,3,2008-9-6,备注
if @end >0
print 'ok'
if exists(select * from sysobjects where name = 'proc_addAppliers')
drop proc proc_addAppliers
gocreate proc proc_addAppliers
@sum int output,
@num varchar(50),
@name varchar(50),
@level int,
@date varchar(50),
@note varchar(50)
asinsert into supplier(supplierNo,supplyGoodName,supplyGoodSafe,supplierActionTime,supplierNote)
values(@num,@name,@level,@date,@note);select @sum =count(*)from supplier where supplierNo =@num
godeclare @end int
exec proc_addAppliers @end output,'11','orb',3,'2008-9-6','备注'
if @end >0
print 'ok'
GO
改过后的