Wednesday 15 July 2020

How to generate alpha numeric random numbers using function in MS SQL Server

///////////// Sql query


SELECT LEFT(REPLACE(CONVERT(VARCHAR(255),NEWID()),'-',''),10)+RIGHT(REPLACE(CONVERT(VARCHAR(255),NEWID()),'-',''),10)


--------------- for more secure string

SELECT LEFT(REPLACE(CONVERT(VARCHAR(255),NEWID()),'-',''),4) + RIGHT(REPLACE(CONVERT(VARCHAR(255),NEWID()),'-',''),4) +
LEFT(REPLACE(CONVERT(VARCHAR(255),NEWID()),'-',''),4) +
RIGHT(REPLACE(CONVERT(VARCHAR(255),NEWID()),'-',''),4)
--------------- Result

A6A1B0FA27A405B38515

CBB8E0390AF48984


No comments:

Post a Comment

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...