Blue Ridge Software LLC
  Encryption
Services
  Webmaster
Services
  Programming   Software   About Us

Program Snippets

  SQL 2000 - Auto-increment on insert (Add To Favorites)
INSERT INTO TblDesignation
SELECT 
	CASE 
		WHEN MAX(SNO) IS NULL THEN 1
		ELSE MAX(SNO)+1
	END, 'Manager'
FROM TblDesignation;
© 2013- Blue Ridge Software LLC