Let me fine tune my question here. What I mean to say is the way we can write stored procedures in C, perl etc in Postgres specifying the language parameter at the end of stored procedure, compared to that, in SQL Server 2000 I've seen SP writing in pure SQL only.
Can you write Stored Procedures in SQL Server 2000 or Oracle in different programing languages as well ?
Thanks
~Jas
On 8/15/07, Trevor Talbot
<quension@xxxxxxxxx> wrote:
On 8/14/07, Jasbinder Singh Bali < jsbali@xxxxxxxxx> wrote:
> I was wondering if any other database has language interface for different
> programing languages such as C , perl , python etc the way postgresql has.
Assuming you mean stored procedures, Microsoft's SQL Server hosts the
CLR, which means pretty much any language capable of targeting .NET
will work. The mechanisms behind this are quite involved, to
guarantee different levels of security and reliability; it's rather
interesting to dig into.
It is just one platform though, so might not be quite what you had in mind :)
