Visual APL and SQL Server 2005, Part 1: Stored Procedures

Webcasts related to APLNext's VisualAPL. Note: Webcasts are downloadable or viewable as a streaming video with start/stop and pause operations.

Moderator: Tech Support

Visual APL and SQL Server 2005, Part 1: Stored Procedures

Postby phpbb_admin » August 16th, 2007, 2:25 pm

Thursday, March 22, 2007 at 10:00am EST

This webcast will show how to create Visual APL assemblies which integrate with SQL Server 2005 as stored procedures!

Integrating Visual APL assemblies with SQL Server 2005

This webcast will show the basics of deploying Visual APL assemblies to a database in Microsoft SQL Server 2005, and using methods in your deployed assemblies as stored procedures.

Stored procedures are the most common form of database automation in SQL Server 2005, and using Visual APL to integrate your functions and code directly into SQL for use as stored procedures is a powerful tool.

Examples shown in this webcast include:

Enabling the CLR on a database in SQL Server 2005.

How to add the common Visual APL assemblies to a database.

Introduction to the Microsoft.SqlServer.Server namespace, which is the Microsoft namespace that contains all objects, types, and functions for interacting with SQL Server.

Create a class library, create a method, and mark that method with the Microsoft.SqlServer.Server.SqlProcedure attribute. Marking a method with this attribute allerts SQL Server that the method can be used as a stored procedure once the assembly has been deployed.

Deploy your newly created Visual APL assembly to the SQL database.

Call your method as a stored procedure from SQL queries, and even call your stored procedure from other stored procedures!
Attachments
meeting26_Thursday, March 22, 2007 (GST) - Visual APL and SQL Server 2005, Part 1_ Stored Procedures.asf
(13.91 MiB) Downloaded 918 times
phpbb_admin
Site Admin
 
Posts: 82
Joined: February 7th, 2007, 11:32 am

Return to VisualAPL Webcasts

Who is online

Users browsing this forum: No registered users and 2 guests

cron