sql server 生成 uuid，sqluuid

来源： javaer 分享于 2019-09-11 点击 739 次点评：54

select SUBSTRING(uuid,1,8)+SUBSTRING(uuid,10,4)+SUBSTRING(uuid,15,4)+

SUBSTRING(uuid,20,4)+SUBSTRING(uuid,25,12) from (select cast(NEWID() as varchar(36)) as uuid ) s

SELECT * FROM T_MONTH_STORAGE WHERE PRODUCT_CODE='3209523546151E'

暂无相关文章