Click here to Skip to main content
15,867,330 members
Home / Discussions / Database
   

Database

 
AnswerRe: How to replace six chracters from middle from any string ?? Pin
PIEBALDconsult15-Sep-14 7:39
mvePIEBALDconsult15-Sep-14 7:39 
AnswerRe: How to replace six chracters from middle from any string ?? Pin
Kiran Upadhyay27-Sep-14 21:55
Kiran Upadhyay27-Sep-14 21:55 
QuestionHow do I sort the table? like the sample Pin
Mohammad Akhondi13-Sep-14 3:06
Mohammad Akhondi13-Sep-14 3:06 
AnswerRe: How do I sort the table? like the sample Pin
Eddy Vluggen13-Sep-14 3:11
professionalEddy Vluggen13-Sep-14 3:11 
AnswerRe: How do I sort the table? like the sample Pin
George Jonsson13-Sep-14 7:57
professionalGeorge Jonsson13-Sep-14 7:57 
Questionalphanumeric number generation Pin
AMRITESH ASTHANA11-Sep-14 1:43
AMRITESH ASTHANA11-Sep-14 1:43 
AnswerRe: alphanumeric number generation Pin
Eddy Vluggen11-Sep-14 3:02
professionalEddy Vluggen11-Sep-14 3:02 
AnswerRe: alphanumeric number generation Pin
George Jonsson13-Sep-14 8:19
professionalGeorge Jonsson13-Sep-14 8:19 
You could have three columns in your table called
company_name of type varchar(5) (or whatever length you desire)
purchase_city of type varchar(5) (or whatever length you desire)
asset_sn of type int

Make these columns unique so you can't add the same number twice. Index name could be ix_asset_number

When you add a new inventory item you first get the last registered row for the company and city.
SELECT LAST(asset_sn) AS AssetNumber FROM assets WHERE company_name = 'XYZ' AND purchase_city = 'MUM';

Then increment the AssetNumber with 1 and insert the new record.
GeneralRe: alphanumeric number generation Pin
AMRITESH ASTHANA14-Sep-14 0:06
AMRITESH ASTHANA14-Sep-14 0:06 
GeneralRe: alphanumeric number generation Pin
George Jonsson14-Sep-14 0:12
professionalGeorge Jonsson14-Sep-14 0:12 
Questioncreate a folder in a file server using xp_create_subdir Pin
Member 128472110-Sep-14 16:37
Member 128472110-Sep-14 16:37 
AnswerRe: create a folder in a file server using xp_create_subdir Pin
Mycroft Holmes14-Sep-14 5:45
professionalMycroft Holmes14-Sep-14 5:45 
QuestionEmployee Year Calculation Pin
Jassim Rahma9-Sep-14 2:26
Jassim Rahma9-Sep-14 2:26 
QuestionRe: Employee Year Calculation Pin
Eddy Vluggen9-Sep-14 2:59
professionalEddy Vluggen9-Sep-14 2:59 
AnswerRe: Employee Year Calculation Pin
Jassim Rahma9-Sep-14 3:02
Jassim Rahma9-Sep-14 3:02 
GeneralRe: Employee Year Calculation Pin
Eddy Vluggen9-Sep-14 8:43
professionalEddy Vluggen9-Sep-14 8:43 
SuggestionRe: Employee Year Calculation Pin
Kornfeld Eliyahu Peter9-Sep-14 10:38
professionalKornfeld Eliyahu Peter9-Sep-14 10:38 
QuestionRe: Employee Year Calculation Pin
Eddy Vluggen10-Sep-14 10:07
professionalEddy Vluggen10-Sep-14 10:07 
AnswerRe: Employee Year Calculation Pin
Kornfeld Eliyahu Peter10-Sep-14 10:20
professionalKornfeld Eliyahu Peter10-Sep-14 10:20 
QuestionMySQL CREATE EVENT Question Pin
Jassim Rahma8-Sep-14 23:08
Jassim Rahma8-Sep-14 23:08 
AnswerRe: MySQL CREATE EVENT Question Pin
Eddy Vluggen9-Sep-14 8:51
professionalEddy Vluggen9-Sep-14 8:51 
QuestionArabic langauge not display when i make search by arabic langauge why Pin
ahmed_sa5-Sep-14 20:44
ahmed_sa5-Sep-14 20:44 
AnswerRe: Arabic langauge not display when i make search by arabic langauge why Pin
Bernhard Hiller7-Sep-14 22:25
Bernhard Hiller7-Sep-14 22:25 
AnswerRe: Arabic langauge not display when i make search by arabic langauge why Pin
Richard Deeming8-Sep-14 2:02
mveRichard Deeming8-Sep-14 2:02 
QuestionSelect records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Ambertje4-Sep-14 0:07
Ambertje4-Sep-14 0:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.