Tuesday 27 September 2016

Generate random alphanumeric string using sql server Comma table exp



WITH n(n) AS (
SELECT 1 UNION ALL SELECT n+1 FROM n WHERE n<62
)
SELECT LEFT(
(SELECT ''+SUBSTRING('0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZqwertyuiopasdfghjklzxcvbnm',n,1)

FROM n ORDER BY NEWID() FOR XML PATH('')),25)


//result//

//zV0hOY7bpqNJcAMjUakg1BnyX

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 ,","...