R
riversmithco
Does anyone have an example of getting a return value back from a
stored proc using the SqlHelper data block? This should be so easy!
Here is my stored proc:
CREATE PROCEDURE AddEmployee
(
@SessionID varchar(24),
@EmployeeID varchar(6)
)
AS
IF (SELECT COUNT(*) FROM Employees WHERE EmployeeID = @EmployeeID) = 0
BEGIN
INSERT INTO Employees
(
SessionID,
EmployeeID
)
VALUES
(
@SessionID,
@EmployeeID
)
RETURN 1
END
ELSE
RETURN 0
GO
Thanks
stored proc using the SqlHelper data block? This should be so easy!
Here is my stored proc:
CREATE PROCEDURE AddEmployee
(
@SessionID varchar(24),
@EmployeeID varchar(6)
)
AS
IF (SELECT COUNT(*) FROM Employees WHERE EmployeeID = @EmployeeID) = 0
BEGIN
INSERT INTO Employees
(
SessionID,
EmployeeID
)
VALUES
(
@SessionID,
@EmployeeID
)
RETURN 1
END
ELSE
RETURN 0
GO
Thanks