This tutorial builds up a click-through tracking application that you can use to measure the number of clicks on any given link in your site, even external links. It demonstrates how to use SQL Server stored procedures and commands from Dreamweaver, in conjunction with an interactive demo. All the application code is free for download and re-use in your own pages.
This tutorial is suitable for beginner to intermediate level, and requires SQL Server installed on your machine (free evaluation edition available from www.microsoft.com/sql/evaluation/trial/) and/or your webhosting provider.
Now with interactive Flash movies showing you step by step how to create the application in DreamweaverMX!
The particular SP that you refer too for retrieving the identity of an inserted record is not covered in this tutorial. For this i recommend everybody to use the excellent extension by http://www.basic-ultradev.com, which is actually updated to use with DMX 2004.
I believe i show some more advanced uses of Stored Procedures, which are normally created as recordsets outside SQL Server, instead of the common @@identity procedure, which can be found on the internet very easy as an tutorial. These more advanced Stored Procedures are retrieved with the Commands dialog of DMX.
Please be more specific what you want to see, using Stored Procedures and maybe i can use this make a future tutorial that suites your needs.
The article is entitled "Using Stored Procedures and Commands in DWMX", and then proceeeds to use an extension to do a very basic SQL Stored Procedure function (@@IDENTITY) via an old Ultradev extension (why use this in article about DW MX?)
I would have preferred to see the use of the builtin capability of SQL Server to return an inserted ID. My goal is to be able to use the Commands dialog to make the recordset, and then use this recordset to do the insert, update, and deletions using the application wizards in DW MX 2004 (which are the same as DW MX) . The main advantage I see in DW MX/2004 is the quick assembly of forms with formatted fields pulled from the database (DW creates all the text boxes, checkboxes, etc. from looking at the data fields in the fields chosen for the recordset).
I will continue to look for a tutorial on using SPs in particular.....