cancel
Showing results for 
Search instead for 
Did you mean: 

Generate unique 8 to 10 char string

former_member940248
Discoverer
0 Kudos

Hi,

I am MS Sql Server developer. Just I started with HANA. I would like to know how can we generate unique 8 to 10 char string for password column.


Thanks

former_member940248
Discoverer
0 Kudos

Sorry

this

select substring(newuid(),0,8) from dummy;

will not provide fully unique string.

former_member940248
Discoverer
0 Kudos

Is there any one can help?

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member456023
Contributor

Hi,

Create Unique identifier on SAP HANA Database using SQLScript.

SQLScript NEWUID function creates a unique identifier in SAP HANA database.

command -

SELECT NEWUID() FROM DUMMY;

Thanks
Ashraf

former_member940248
Discoverer
0 Kudos

But NewUID() generates more then 10 chars.

former_member456023
Contributor
0 Kudos

We can use substring function and get required no of chars.

ex -

select substring(newuid(),0,8) from dummy;

Hope it helps.

Thanks
Ashraf