SQL-2000 Stored procesure or function

[Steen Andreassen]

Hi Group...

In one of my tables in a SQL-2000 db, do I have a calculated column calling
a user defined function.

That's not a problem, but now I need to update another column in the same
table form this udf.

It seems not to be possible in SQL-2000, so how is such thing normally done
?

Do I need to call e stored procedure from within the function, with the
nessesary parameters, and then let this stored procedure perform the update,
or is it a better idea to change the function used in the computed column to
a stored procedure ?

If so, how am I programming the call to the procedure?
Something similar to the function-call which is done like:

CREATE TABLE table1 (
column1 int AS dbo.fn_calculate_something (parameter1, parameter2),
column2 .....
column3.....
)

Thanks in advance.

Steen

[Erland Sommarskog]

Steen Andreassen (st*****@FJERNpost3.tele.dk) writes:

In one of my tables in a SQL-2000 db, do I have a calculated column
calling a user defined function.

That's not a problem, but now I need to update another column in the same
table form this udf.

It seems not to be possible in SQL-2000, so how is such thing normally
done ?
Through a trigger.
Do I need to call e stored procedure from within the function, with the
nessesary parameters, and then let this stored procedure perform the
update, or is it a better idea to change the function used in the
computed column to a stored procedure ?

You cannot call a stored procedure from a UDF.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp