sql server 年月日时分秒+8位随机数

最新推荐文章于 2022-03-17 23:53:21 发布

摄念子

最新推荐文章于 2022-03-17 23:53:21 发布

阅读量2.8k

点赞数

分类专栏： sql server

本文链接：https://blog.csdn.net/longtingjing/article/details/47039429

版权

sql server 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

一、8位随机数据存储过程

/****** Object:  StoredProcedure [dbo].[pro_rand8]    Script Date: 2015-07-24 12:36:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[pro_rand8](@rand varchar(8)='8888888888888' out)
	
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	declare @str varchar(30)	
	set @str=convert(varchar(30),CONVERT(DECIMAL(20,20),rand()))
	set @rand=SUBSTRING(@str,3,8)
   END

二、年月日时分秒+8位随机数

declare @rand varchar(8)
execute pro_rand8
        @rand=@rand output
select convert(varchar(19),getdate(),112)+DateName(hour,GetDate())+ DateName(minute,GetDate())+DateName(second,GetDate())+@rand as today
select DateName(hour,GetDate())+ DateName(minute,GetDate())+DateName(second,GetDate())