| Subject | stored procedure as function |
|---|---|
| Author | rj1102 |
| Post date | 2006-11-19T12:26:52Z |
FB2:
can i use a stored procedure as a function in a select statement?
f.e.:
SELECT EmplId, Salary, SP1(Salary)
where SP1 is created as:
CREATE PROCEDURE SP1 (Salary INTEGER)
RETURNS (ReturnSalary INTEGER)
AS
BEGIN
ReturnSalary = 2*Salary; /* actualt some more complex calculation
with Salary */
END
can i use a stored procedure as a function in a select statement?
f.e.:
SELECT EmplId, Salary, SP1(Salary)
where SP1 is created as:
CREATE PROCEDURE SP1 (Salary INTEGER)
RETURNS (ReturnSalary INTEGER)
AS
BEGIN
ReturnSalary = 2*Salary; /* actualt some more complex calculation
with Salary */
END