Generate Random Number in SQL Numeric and Password / String

Random Number

SELECT ABS(CHECKSUM(NewId())) % 10000 AS [NewID]

SELECT ABS(CAST(CAST(NEWID() AS VARBINARY) AS INT)) AS [RandomNumber]

select FLOOR(RAND(CHECKSUM(NEWID()))*(99999-10000)+10000) as [newiy]

Random String

SELECT NEWID() AS [NewID]