Archive for May, 2009

Don’t use @@IDENTITY

Tuesday, May 26th, 2009

If you’re using SQL Server, and you’re inserting records into a table with an auto increment primary key, I suggest you don’t use @@IDENTITY to retrieve the previously inserted Id. Rather use SCOPE_IDENTITY(). The reason for this is that @@IDENTITY gives you the last generated Id in the current session vs. SCOPE_IDENTITY() gives you the [...]

Posted in Programming | No Comments »

Google and search ranking

Monday, May 4th, 2009

I’ve recently finished a new site for a client, and in the process of developing, I uploaded a test site to a web server for the client to review. Since going live with the actual site, I left the test site up and running (in the assumption that its less effort to leave it up [...]

Posted in Dwakn, Web | No Comments »