DZone Snippets: from code http://snippets.dzone.com/posts Sun, 07 Sep 2008 03:51:33 GMT DZone Snippets: from code MSSQL 2005 - Add ID value to ID column when INSERTING http://snippets.dzone.com/posts/show/4521 // @TableName is obviously the TABLE name u use <br />// @ColumnName is obviously the COLUMN name u use <br /> <br /><code> <br />---Get next ID number <br /> DECLARE <br /> @ID int <br /> <br /> IF (SELECT count(*) FROM @TableName ) > 0 <br /> BEGIN <br /> SELECT @ID = max(ColumnName ) from @TableName <br /> SET @ID = @ID + 1 <br /> END <br /> ELSE <br /> BEGIN <br /> SET @ID = 1 <br /> END <br /></code> Tue, 11 Sep 2007 07:50:29 GMT http://snippets.dzone.com/posts/show/4521 dubby (Dave)