SqlServer
共 1 篇文章
使用SqlServer2008
1.一个简单的函数,去掉NEWID()中的横线,生成32位的UUID USE [incubator] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION [dbo].[fun_getid32](@newid varchar(36)) RETURNS VARCHAR(32) AS BEGIN DECLARE @id VARCHAR(32); select @id=SUBSTRING(@newid,1,8)+SUBSTRING(@newid,10,4)+SUBSTRING(@newid,15,4)+ SUBSTR…
2013-03-26 17:21 · SqlServer