SQL: 将int型转换为UNIQUEIDENTIFIER

时间：2017-11-11 15:45:58 阅读：271 评论：0 收藏：0 [点我收藏+]

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)

原文：http://www.cnblogs.com/kuojiang/p/7819088.html

踩

(0)

评论一句话评论（0）

分享档案

更多>