hi
these are my table in database
House_classification
|
Id
|
classification
|
behcode
|
Totalproduct
|
|
1
|
electric
|
1111
|
|
|
2
|
Furniture
|
1111
|
|
|
3
|
Cloth
|
2222
|
|
and House_p table
|
d
|
name
|
classification
|
behcode
|
|
1
|
iron
|
Electric
|
1111
|
|
2
|
Vaccum cleaner
|
Electric
|
1111
|
|
3
|
Sofa
|
Furniture
|
1111
|
|
4
|
Scarf
|
Cloth
|
222
|
and i use grid view that have edit button this is my SP that i can edit classification column in House_classification table
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[classmanagerup]
@ID varchar(20),
@Classification nvarchar(50)
as
begin
update House_classification set Classification=@Classification
where ID=@ID;
select ID, Classification,Totalproduct
from House_classification
where BehCode=1116
end
now i want change my SP that update Classification column in both table House_p and House_classification table How i can do it?
thanks
