create PROCEDURE App_Customers_Update
@CustomerID int,
@Phone nvarchar(32),
@FamilyTypeID int,
@IDCardNo nvarchar(32),
@CustomerLevel int,
@FamilyTypeName nvarchar(64)
AS
Update Customers
set Phone = @Phone,FamilyTypeID = (select FamilyTypeID from FamilyType where FamilyTypeName = @FamilyTypeName),IDCardNo = @IDCardNo,CustomerLevel = @CustomerLevel
where CustomerID = @CustomerID
RETURN
@CustomerID int,
@Phone nvarchar(32),
@FamilyTypeID int,
@IDCardNo nvarchar(32),
@CustomerLevel int,
@FamilyTypeName nvarchar(64)
AS
Update Customers
set Phone = @Phone,FamilyTypeID = (select FamilyTypeID from FamilyType where FamilyTypeName = @FamilyTypeName),IDCardNo = @IDCardNo,CustomerLevel = @CustomerLevel
where CustomerID = @CustomerID
RETURN
然后在查询分析器下运行这句select FamilyTypeID from FamilyType where FamilyTypeName = 监视得到的值,看看什么结果
反而要通过 @FamilyTypeName这个去关联?
赋值给一个变量
然后print @a看一下有没有值啊
最好再跟踪一下传进来的@FamilyTypeName