search

fjtello / SQL-C-sharp

Common programming and coding tips and howtos
0 stars 0 forks source link

sql syntax #Get_NewId #22

Open fjtello opened 7 years ago

fjtello commented 7 years ago

DECLARE @v AS VARCHAR(20);

DECLARE @inte AS VARCHAR(50);
SET @inte = NEWID();

SET @v = REPLACE(REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(30), GETDATE(), 121), '-', ''), ' ', ''), ':', ''), '.', '') + 
            RIGHT('0000' + CONVERT(VARCHAR(4), ABS(CHECKSUM(@inte)) % 10000), 4);