January 17, 2002 at 4:06 am
Hi,
I need to store the connectionIDs in a table. I want to fire a proc from within a trigger, but I don't know how to return the connectionID, can anyone help?
This is the proc so far:
CREATE PROCEDURE dbo.uspCurrentUserUpdate
@UserName VARCHAR(20),
@SecurityToken INTEGER
AS
IF EXISTS(
SELECT 1 FROM CurrentUsers CU
WHERE CU.UserName = @UserName AND CU.SecurityToken = @SecurityToken)
UPDATE CurrentUsers
SET ConnectionID = 1
ELSE
INSERT INTO CurrentUsers
(UserName,
SecurityToken,
ConnectionID)
VALUES
(@UserName,
@Securitytoken,
???????)
January 17, 2002 at 5:05 am
January 19, 2002 at 1:59 pm
Thanks!!
January 19, 2002 at 8:50 pm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply