Saturday 16 January 2021

Generate or Create GUID random in MS SQL Server with datetime

 /////////////////// Sql

select LEFT(REPLACE(CONVERT(VARCHAR(255),NEWID()),'-',''),10)+RIGHT(REPLACE(CONVERT(VARCHAR(255),NEWID()),'-',''),10)+format(getdate(), 'yyyyMMddHHmmssfff')GUID


///////// Result


11F7A1525A049FB6145E20210116183025690

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