There’s a good article by Scott Guthrie here that describes the basics. Just scroll down to Tutorial 5 for the INSERT specific bit – it is pretty straightforward and there is no point my repeating it here. One point to note, however, and why I wrote this particular post. The key step in getting this [...]
Entries Tagged as 'SQL'
Tips for returning IDENTITY values from INSERT
January 14th, 2007 · No Comments · ASP2, SQL
Tags: programming·tips
Determining row counts for all tables in a database
January 11th, 2007 · No Comments · ASP2, SQL
Here is a usful snippet if you want a way to get the number of rows in each table in your database. I use this in an admin-only page of the web application to provide some at-a-glance statistics. It is also really useful in unit tests for checking the correctness of business logic that may [...]
Adding ASP Role tables to your own database
December 29th, 2006 · No Comments · .net, ASP2, SQL
This is still work in progress, but I want to incorporate the user role management tables within my own database, as the concept of users and their distinct roles ties right in with the core business model of the new site. The following link explains the standalone tool to create the tables: ASP.NET SQL Server [...]
Tags: programming