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…"
[Andres Aguiar]
