SQL and external code

[rmatthew]

I have an an api that accesses an external time keeping device that I would like to use as a default value in an SQL Table column.

 

I know that I cannot do it directly, but is there a way to write an SQL function/stored proceedure that can retreive a value from an external API?

Edited February 1, 2006 by rmatthew