alter proc updatet3
@KHDM VARCHAR(255),
@KHDM2 varchar(255)
as
DECLARE @ID INT ;
declare @id2 int ;
declare @row int;
--declare @khdm varchar(255)
SELECT @ID=ID FROM T1 WHERE KHDM=@KHDM
select @id2=ID from t1 where KHDM=@KHDM2
--PRINT @ID;
--PRINT @ID2;
UPDATE T2 SET ZD_id=@ID2 where ZD_id=@ID
set @row=@@ROWCOUNT
if( @@ROWCOUNT>0)
begin
print str(@row)
end
ELSE
begin
print str(@row)
end
@KHDM VARCHAR(255),
@KHDM2 varchar(255)
as
DECLARE @ID INT ;
declare @id2 int ;
declare @row int;
--declare @khdm varchar(255)
SELECT @ID=ID FROM T1 WHERE KHDM=@KHDM
select @id2=ID from t1 where KHDM=@KHDM2
--PRINT @ID;
--PRINT @ID2;
UPDATE T2 SET ZD_id=@ID2 where ZD_id=@ID
set @row=@@ROWCOUNT
if( @@ROWCOUNT>0)
begin
print str(@row)
end
ELSE
begin
print str(@row)
end