Views : 45 Clicks : 0

Generate AlphaNumeric Identity Column in SQL Server

By nisha_singh via www.sqlservercurry.com
Submitted On December 13, 2011

Let us suppose you have a requirement where you want to have an alphanumeric identity column that has characters and numbers and you want these numbers to be incremental. Eg: Customer ids like cus0000001, cus0000002, etc. You can use any of the following methods

  0 Comments   Tags: Database

Freshly Arrived

1. 10 Most Useful Wordpress Comment Plugins
2. To pass limits with store procedure in MySQL
3. Hello Vertx Javascript
4. Page redirection with Live time left preview using jquery
5. A Useful String Manipulation Extension for JavaScript

Getting Hotter

1. PHP Tutorial: String Matching - Episode 2 - The Wrath of Khan Academy
2. Pagination and Switch Case in Where clause in SQL Server