In a comment to my previous post, I was pointed to a Yukon presentation that was given in Netherland´s DevDays that has some interesting details.
I am quite dissappointed with what I saw. It seems that it will be very similar to what we can do in other databases with Java (or COBOL, C, etc). You will need to add an assembly to the database:
CREATE ASSEMBLY events FROM ‘events.dll’
And then define a stored procedure that will be bound to a static method in a class:
CREATE PROCEDURE check_inventory EXTERNAL NAME ‘events:CInventory.check_level’
Where Cinventory is a class in the 'event' assembly that has a check_level static method.
In Oracle you write:
CREATE PROCEDURE swap (x IN OUT NUMBER, y IN OUT NUMBER) AS LANGUAGE JAVA NAME 'Swapper.swap(int[], int[])';
Being able to write stored procedures in a .NET language is better than writing them in T-SQL, but it seems that Microsoft is just playing catch-up…
7:32:32 PM
|