Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 1314
Home > Codes >

For generating 6 char unique ID.

Jobin
Posted by Jobin under Sql Server category on | Points: 40 | Views : 1907
Post Code | Search Codes | Code Home  
SUBSTRING(CONVERT (CHAR(36),NEWID()),0,7)
Alert Moderator 
Bookmark It

Comments or Responses

Posted by: Muhsinathk on: 6/8/2012 Level:Bronze | Status: [Member] | Points: 10
[IDwithChar] AS ('00000'+CONVERT([varchar](10),[ID],0)) PERSISTED

Login to post response

Latest Code Snipptes