Breaking News: Grepper is joining You.com. Read the official announcement!

sql function sequence format code generator

Charles Russel Zafe answered on July 19, 2022 Popularity 1/10 Helpfulness 1/10

answer sql function sequence format code generator

related sql function sequence format code generator

sql function sequence format code generator

Comment

CREATE FUNCTION generate_category_no() 
RETURNS CHAR(20) 
AS 
BEGIN 
    DECLARE @category_no CHAR(20) 
    SET @category_no = (SELECT MAX(category_no) FROM category WHERE category_no LIKE CONCAT('CAT-', YEAR(getDate()), '-', MONTH(getDate()), '-%')) 
    IF @category_no is null SET @category_no = CONCAT('CAT-', YEAR(getDate()), '-', MONTH(getDate()), '-000000')
    DECLARE @no INT 
    SET @no = RIGHT(@category_no,6) + 1 
    RETURN CONCAT('CAT-', YEAR(getDate()), '-', MONTH(getDate()), '-', RIGHT('00000' + CONVERT(VARCHAR(10),@no),6))
END
GO

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: format generator sequence sql sql-function

Link to this answer
Share Copy Link

Contributed on Jul 19 2022

Charles Russel Zafe

0 Answers Avg Quality 2/10

Closely Related Answers

sql function sequence format code generator

Comment

INSERT INTO category (category_no, category_name) VALUES (dbo.generate_category_no(),'BMW');
INSERT INTO category (category_no, category_name) VALUES (dbo.generate_category_no(),'JAGUAR');

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: format generator sequence sql sql-function

Link to this answer
Share Copy Link

Contributed on Jul 19 2022

Charles Russel Zafe

0 Answers Avg Quality 2/10

sql function sequence format code generator

Contents

More Related Answers

sql function sequence format code generator

Closely Related Answers

sql function sequence format code generator

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.