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

Folder Names with Spaces in XCOPY doesn't work using batch or .bat file

//////////////////////////

Solution : ==>

 It's working if the source and destination folder and file with DIR is in the DOUBLE QUOTATION MARKS like given below-


xcopy "E:\ Folder name 1\Folder name 2\Folder name 3\file 2007130100.txt" "E:\Folder name 11\Folder name 12\Ftp\Folder name 13\"