kronass

[QUOTE=Ramy Mahrous;855759]Dynamic SQL is very risky!![/QUOTE] I'm Sorry but this is totally not true because it depends on the person who wrote it because in sql you should never ever ever do concatenation to make queries, you should use parametrized queries. and if the columns or the tables were dynamic …

Greetings, I will answer what I could understand, In the ID part you can concatenate with the Display Text you can make it YouID$YourText and then when you get the query string in the server side split them and take the id and text. I don't prefer this but it …

I Agree with Narue about the people who said you should go with C++ because you will not understand classes very well in java is totally not true. because classes is the implementation of object oriented paradigm and it has its own rules and concepts. java, c++ and other languages …

Hi thank you very much for posting your ERD I like that kind of people who likes other opinions before they start implementing I think it is more reliable in work. Lets see I will not talk about the whole ERD i will talk only part of it when i …

in this case you need to add journey station table <journey_stations> journey_id (fk) station_id (fk) use the same schema that timothybard provided but in <Journey table> remove station_ID and add <journey_stations> in result you will get <station table> stationid (pk) station_name <Journey table> journeyid (pk) trainid (fk) <journey stations> --> …

Thank you very much for the tip but i have a question in this case I have to add an other join to the select Query and as every one knows that the joins decrease the performance in the query and they recommend to decrease the joins as much as …