SQL Essentials App

"Time function accurate to nanosecond"

Sysdatetime (), sysutcdatetime ()---- accuracy depends on the computer hardware and the Windows version number of the instance that is executing the SQL Server

"Generate 10-bit random numbers without repeating"

Select Right (1000000000 + convert (bigint,abs (checksum (NEWID ())), 10)

"Generate non-recurring IDs for 18-bit pure numbers"

Select SUBSTRING (replace (replace (replace (varchar (), sysdatetime (), ' ', '), '-', '), ': ', '), '. ', "), 3, + right (1000000000 + convert (bigint,abs (checksum (NEWID ())), 6)

"Generate non-recurring IDs for 20-bit pure numbers"

Select Left (replace (replace (replace (varchar (), sysdatetime (), ', '), '-', '), ': ', '), '. ', + Right (1000000000 + convert (bigint,abs (checksum (NEWID ())), 6)

SQL Essentials App