ITeye博客

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