Generate Random alphanumeric Primary Key in SQL Server

SajidHus...

SOLVED CLOSED ACTIVE ANSWERED
User: SajidHussa
Posted: on Oct 05, 2019 12:36 AM
Forum: SQL Server
Answer: 1
Views: 2386

i want gernate 100000 coupan but all are unique and in alphanumeric format

like :Ab02ER45A12

a12gd45db2d4fg1

character lenght 7

Download FREE API for Word, Excel and PDF in ASP.Net

pandeyis...

0 6

Reply
ANSWER
User: pandeyism
Replied: on Oct 07, 2019 03:17 AM
Modified: on Oct 07, 2019 03:17 AM
Report

Hi SajidHussa,

Take reference to below query change accordingly to your requirement.

SQL

DECLARE @Table TABLE (Id UNIQUEIDENTIFIER DEFAULT NEWID() PRIMARY KEY)
DECLARE @counter INT
SET @counter = 1
WHILE (@counter <= 1000)
BEGIN
INSERT INTO @Table VALUES(NEWID())
SET @counter = @counter + 1
END
SELECT LEFT(CONVERT(VARCHAR(MAX),Id),8) + RIGHT(CONVERT(VARCHAR(MAX),Id),6) Id FROM @Table

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Generate Random alphanumeric Primary Key in SQL Server

Company

Explore

Follow us

Contact Us