Stored procedure, hvis select tom then insert
SELECT packeteer_idFROM net_packeteer
WHERE device_id = @device_id
Hvis denne select er tom vil jeg gerne lave dette
INSERT INTO net_packeteer(device_id)
VALUES(@device_id)
Og så bagefter lave igen
SELECT packeteer_id
FROM net_packeteer
WHERE device_id = @device_id
Hvordan fanger jeg om selecten er tom, så det andet kan udføres?
Synes ikke helt jeg kan få det til at virke.
CREATE PROCEDURE md_packeteerSelProc
( @device_id [id],
@user_id [id])
AS
BEGIN
IF dbo.accessDevice(@user_id, @device_id) = 0 BEGIN
RAISERROR 50000 'md_packeteerSelProc: User do not have access to that device.'
RETURN(1)
END
SELECT packeteer_id
FROM net_packeteer
WHERE device_id = @device_id
RETURN(0)
END
GO