时间:2021-07-01 10:21:17 帮助过:2人阅读
DECLARE @I INT
SELECT @I=123456
SELECT CAST(CAST(@I AS varbinary(16)) AS UNIQUEIDENTIFIER)
SELECT CAST(CAST(@I AS binary(16)) AS UNIQUEIDENTIFIER)
SELECT CAST(CAST(@I AS binary(4))+CAST(@I AS binary(4))+CAST(@I AS binary(4))+CAST(@I AS binary(4)) AS UNIQUEIDENTIFIER)
SELECT CAST(CAST(REPLICATE(CAST(@I AS binary(4)),4) AS binary(16)) AS UNIQUEIDENTIFIER)
SELECT CAST(CAST(HASHBYTES(‘MD5‘,CAST(@I AS varbinary(4))) AS binary(16)) AS UNIQUEIDENTIFIER)
SELECT CAST(CAST(HASHBYTES(‘MD5‘,CAST(@I AS varchar(20))) AS binary(16)) AS UNIQUEIDENTIFIER)SQL: 将int型转换为UNIQUEIDENTIFIER
标签:ast color index var class 转换 key har line