1. GeniusConnect support
  2. Database
  3. MS SQL Server
  4. MAX(column) + 1 returns NULL
Administrator
  •  Admin
  • Advanced Member Topic Starter
2004-05-12T23:23:00Z
if no records exists max + 1 will return NULL
Example:
Select (max(MyID)+1) from MyTable

To avoid this problem use:
Select ISNULL((max(MyID)+1),1) from MyTable
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
  •  Admin
  • Advanced Member Topic Starter
2015-05-29T00:58:00Z
 Atom Feed Rss Feed
Similar Topics
  1. GeniusConnect support
  2. Database
  3. MS SQL Server
  4. MAX(column) + 1 returns NULL