ColdFusion, WordPress, Flash & other web things


Archive for the 'SQL' Category

SQL Server & IDENTITY

I’ve been using the @@IDENTITY keyword for years now to retrieve the ID of a newly created record in SQL Server but we discovered the other day that its behaviour is not always as straight forward as we thought.