Syntax to Create a surrogate key

Database

Syntax to Create a surrogate key

Need to create a table with surrogate keys.
2 REPLIES
N/A

Re: Syntax to Create a surrogate key

You can use the CSUM function for this.
N/A

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