Hi. I need auto-Generate number like Ticket-0001 Varchar : Ticket- Int : 0001 it should me increment next time How can i do? i am using vb.net & sql server 2005 ...