Converting Oracle built-in functions to SQL Server

• Tricia Colwell

  SSC Enthusiast

  Points: 164

  More actions

  September 16, 2005 at 8:34 am

  #91298

  I use this select statement:

  SELECT NVL(MAX (KEY),0) FROM JIDS_DATASOURCES)+1

  to get the next primary key for that table when i am inserting a new row in the table.

  How can i convert this over to SQL server and still get the same functionality???

   

  Tricia

• Carl Federl

  One Orange Chip

  Points: 25384

  More actions

  September 16, 2005 at 8:42 am

  #590620

  The Oracle NVL and COALESCE functions behave identically but COALESCE is ANSI standard and is supported by SQL Server.

  This SQL will work for both Oracle and SQL Server

  SELECT COALESCE(MAX (KEY ) , 0 ) + 1

  FROM JIDS_DATASOURCES

  SQL = Scarcely Qualifies as a Language

• Tricia Colwell

  SSC Enthusiast

  Points: 164

  More actions

  September 16, 2005 at 8:51 am

  #590624

  Thanks

  Tricia