0
Debugging Classic ASP in VS08
Posted by Zu on June 24, 2010 in ASP, Visual Studio
1. Go to Control Panel>Administrative Tools>Computer Management. Add IWAM_ComputerName account to the Debugger Users group. 2. Create a Web Application Project in VS 2005 and add .asp files. 3. Create a virtual directory in IIS for the web application project that you created. 4. On the properties tab of the virtual directory in IIS do [...]
Return Inserted Identity from Stored Procedure
Posted by Zu on April 23, 2010 in ASP
Stored Procedure looks like this: ALTER PROCEDURE [dbo].[spInsertSomething] @txtName varchar(255), @txtDisplayName varchar(80), @txtPhone varchar(50) AS BEGIN INSERT INTO tblSomeTable ( txtName , txtDisplayName , txtPhone ) VALUES ( @ txtName , @ txtDisplayName , @ txtPhone ) SELECT NEWID = SCOPE_IDENTITY() END