1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
|
CREATE PROCEDURE arch_broken_agent
@matid int,
@typeid int,
@placeid int,
@login varchar(10),
@type_serial varchar(15)
AS
BEGIN TRANSACTION
DECLARE @old_serial varchar(15)
DECLARE @QUERY varchar(1500)
SET @QUERY = ' select ' + @type_serial + ' INTO TableTempo from agent where placeid=' + CAST(@placeid as varchar(5)) + ' and login =' + @login
EXEC(@QUERY)
SET @old_serial = (SELECT * FROM TableTempo)
DROP TABLE TableTempo
Print @old_serial
IF @old_serial <> 'unknown'
BEGIN
INSERT INTO operation(serial,operationday,login,typeID,stuffID,placeID,status) VALUES(@old_serial,getdate(),@login,@typeid,@matid,@placeid,'BROKEN')
IF @@ERROR <>0
BEGIN
ROLLBACK TRANSACTION
RETURN
END
ELSE
BEGIN
COMMIT
END
END |
Partager