获取日期时间唯一编号 SQLServer存储过程和函数的写法

最新推荐文章于 2024-07-25 14:34:01 发布

hsg77

最新推荐文章于 2024-07-25 14:34:01 发布

阅读量3.8k

点赞数

分类专栏：数据库文章标签：数据库

本文链接：https://blog.csdn.net/hsg77/article/details/8443740

版权

数据库专栏收录该内容

86 篇文章 0 订阅

订阅专栏


GO
/****** Object:  StoredProcedure [dbo].[e_get_datetimestrguid]    Script Date: 12/27/2012 15:07:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<hsg>
-- Create date: <2012-12-27>
-- Description:	<获取日期时间唯一编号>
-- 调用方式：EXECUTE dbo.e_get_datetimestrguid;
-- =============================================
ALTER PROCEDURE [dbo].[e_get_datetimestrguid]
	-- Add the parameters for the stored procedure here	
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	-- Declare the return variable here
	DECLARE @t_dt varchar(30);
	declare @rd_num float;
	declare @rd_str varchar(10);

	-- Add the T-SQL statements to compute the return value here
	set @t_dt=convert(varchar,getdate(),21);
	set @t_dt=replace(@t_dt,'-','');
	set @t_dt=replace(@t_dt,':','');
	set @t_dt=replace(@t_dt,'.','');
	set @t_dt=replace(@t_dt,' ','');
	-- Return the result of the function
	--生成一个椭机数
	select @rd_num=floor(Rand()*99999);
	set @rd_str=convert(varchar,@rd_num);
	--合并一个
	select @t_dt+@rd_str;
END

/****** Object:  UserDefinedFunction [dbo].[a_get_datetimestrguid]    Script Date: 12/27/2012 14:33:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<hsg>
-- Create date: <2012-12-27>
-- Description:	<获取日期时间唯一编号>
-- 调用方式：select dbo.a_get_datetimestrguid();
-- =============================================
ALTER FUNCTION [dbo].[a_get_datetimestrguid]
(	
)
RETURNS varchar(30)
AS
BEGIN
	-- Declare the return variable here
	DECLARE @t_dt varchar(30);
	declare @rd_num float;
	declare @rd_str varchar(10);

	-- Add the T-SQL statements to compute the return value here
	set @t_dt=convert(varchar,getdate(),21);
	set @t_dt=replace(@t_dt,'-','');
	set @t_dt=replace(@t_dt,':','');
	set @t_dt=replace(@t_dt,'.','');
	set @t_dt=replace(@t_dt,' ','');
	-- Return the result of the function	
	RETURN @t_dt;
END