How to Manage this Digit???

Question

hey frnds...
i have a digit like this....
1300000001
after 1300000009
it should be 1300000010
after 1300000099
it should be 1300000100
1300000101
etc
please give me solution if you have
thanks.....

Vulpes · Answer

Here's a C# method to do the same thing:
using System;
class Program {    static void Main()    {       string currentID = "1200000009";       string nextID = GetNextID(currentID);       Console.WriteLine("{0} -> {1}", currentID, nextID);       currentID = nextID;       nextID = GetNextID(currentID);       Console.WriteLine("{0} -> {1}", currentID, nextID);       currentID = "1300000100";       nextID = GetNextID(currentID);       Console.WriteLine("{0} -> {1}", currentID, nextID);       Console.ReadKey();    }
static string GetNextID (string currentID)    {       string nextID;       int year = 2000 + int.Parse(currentID.Substring(0, 2));       int currentYear = DateTime.Today.Year;        if (year == currentYear)       {          int number = 1 + int.Parse(currentID.Substring(3));          nextID = currentID.Substring(0, 2) + number.ToString("D8");       }       else       {          nextID = (currentYear - 2000).ToString("D2") + "00000001";       }       return nextID;         } }
The output is:
1200000009 -> 1300000001 1300000001 -> 1300000002 1300000100 -> 1300000101

Jignesh Trivedi · Answer

hi, Try in SQL Declare @id int = 10
select right(year(getdate()),2) + RIGHT('0000000000' + CAST(@id AS VARCHAR(7)), 7) Also refer my article
http://www.c-sharpcorner.com/UploadFile/ff2f08/auto-incremented-column-with-varchar-and-nvarchar-data-type/ hope this will help you.

Mukesh Kumar Tiwari · Answer

i want to make and identification number for  Patient for a hospital project
in 2013 it will be start from 13
in 2014 it will be start from 14
and it will be of 10 digit...
this type of req i have..
you can give soluaition in both c# or sql....
thanks

Jignesh Trivedi · Answer

so here what problem your are facing?
are you looking solution in which platform SQL or C#?