Generate Six digit unique alphanumeric code in SQL Server

Question

Generate Six digit alphanumeric code in sqltablieid123SSA3ssdf444A12344551223ASAso onBut number not repeat its is uniqueIf exist then next number is generatedI WANT A MAKE A SUCH TYPE OF PROCEDURE IN SQL WHICH I WANT TO USE IN MY CODE

dharmendr · Accepted Answer

Refer below linkshttpsstackoverflowcomquestions26992161howtogeneratealphanumericrandomnumbersusingfunctioninsqlserver2008httpsblogsqlauthoritycom20070429sqlserverrandomnumbergeneratorscriptsqlqueryFor duplicate you need to save the generated number and check while generatingif already exists then generate new one

Generate Six digit unique alphanumeric code in SQL Server

Company

Explore

Follow us

Contact Us