Generate 8 digit random alphanumeric string in sql server

For generate random alphanumeric string in sql server, use following query: SELECT CAST((ABS(CHECKSUM(NEWID()))%10) as varchar(1)) + CHAR(ASCII('a')+(ABS(CHECKSUM(NEWID()))%25)) + CHAR(ASCII('A')+(ABS(CHECKSUM(NEWID()))%25)) + left(NEWID(),5) This will return alphanumeric string with 8 digit.If you want to use this query to sql server function then refer my another blog from following link:Use NEWID() in sql server functi...

Read More

How to use NEWID() in sql server function

Sql server function not allow to use NEWID() function.Solution:-> Create view in same database from following query:CREATE VIEW [dbo].[GetNewID] AS SELECT NEWID() AS new_idNow you can use SELECT new_id FROM [dbo].[GetNewID] instead of NEWID() in your query in sql server functio...

Read More