 |  |  |  |  |  |  |  |
Generate Alpha-Numeric Values in SQL SERVER
Please support our MS SQL advertiser: Intel Parallel Studio Home
Thread Solved |
•
•
Join Date: Jun 2009
Posts: 67
Reputation: 
Solved Threads: 0
Junior Poster in Training
Hi all,
I am creating a windows application. I have a column in the backend - MS sql server 2005 as ID which stores Patient Id.
The values for this column should start with
PT and contain the serial numbers in ascending order.
Eg.
PT001
PT002
PT003
I want to generate this automatically however identity does not allow this type of values.
Then how can I do this?
Is there any way I could do this automatically?
Please help me out!
Thanks in advance!!
I am creating a windows application. I have a column in the backend - MS sql server 2005 as ID which stores Patient Id.
The values for this column should start with
PT and contain the serial numbers in ascending order.
Eg.
PT001
PT002
PT003
I want to generate this automatically however identity does not allow this type of values.
Then how can I do this?
Is there any way I could do this automatically?
Please help me out!
Thanks in advance!!
 |
Similar Threads
- How can I generate sql script with data in sql server 2000? (C#)
- SQL Server Developer, Manchester, UK (Software Development Job Offers)
- Sql server 2005 (MS SQL)
- Retrieve values from sql server 2005 (ASP.NET)
- SQL Server DBA - " Hot " (Software Development Job Offers)
- SQL Server DBA (Software Development Job Offers)
- Autonumber in a SQL Server table (MS SQL)
- Loops in Sql Server Triggers and Stored Procedures (ASP.NET)
- How to auto increment? (ASP.NET)
Other Threads in the MS SQL Forum
- Previous Thread: MS SQL 2005 DTS Trouble...
- Next Thread: Error in If statement
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MS SQL Posts
- Today's Posts
- Unanswered Threads
