Tuesday 27 September 2016

Generate random string using sql server NEWID() method



declare @password varchar(30)
set @password=(SELECT RIGHT(REPLACE(CONVERT(VARCHAR(36),NEWID()),'-',''),26))

select @password

//REsult//

//B067EC4004AA96ED32476E0DC0

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