Syntax to Create a surrogate key

Database
Enthusiast

Syntax to Create a surrogate key

Need to create a table with surrogate keys.
2 REPLIES
Enthusiast

Re: Syntax to Create a surrogate key

You can use the CSUM function for this.
Enthusiast

Re: Syntax to Create a surrogate key

Khab,

CSUM function are retained for backword compatibility (i think).
It is best if we use Ordered Analytical functions.

Vinay