themadprofessor
themadprofessor
About
- Username
- themadprofessor
- Joined
- Visits
- 0
- Last Active
- Roles
- Member
Comments
-
It sounds like you prefer the design end of things rather than the nuts and bolts of coding...if so, you might consider moving towards systems analysis and design.
-
All things being equal, I'd definitely go with database fundamentals. Unless you're planning to go into computer engineering, hardware design or networking, computer architecture might provide some insights to your work but hardly on a day-to-day ba…
-
All things being equal, I'd definitely go with database fundamentals. Unless you're planning to go into computer engineering, hardware design or networking, computer architecture might provide some insights to your work but hardly on a day-to-day ba…
-
About the only way I can think of offhand would be to create a table to hold the value between procedure executions. Then you can retrieve the value in the stored procedure each time it's invoked and update it for the next time.
-
About the only way I can think of offhand would be to create a table to hold the value between procedure executions. Then you can retrieve the value in the stored procedure each time it's invoked and update it for the next time.
-
I suspect the ghost of Codd would want to rise from its grave and bitchslap whoever designed the database...a repeating-items list stuffed into a single column? Big no-no... Frankly, I can't think of an inelegant (let alone an elegant one) way to do…
-
It's a real lame excuse for a game show, that's for sure...
-
One possible way you can do this (assumes you want to add 10% to remaining time - if you want increase of 10% of entire project time, use startDate instead of NOW): SELECT projNo, endDate, endDate + (1.1 * (endDate - NOW() DAYS)) DAYS AS "E…
-
One possible way you can do this (assumes you want to add 10% to remaining time - if you want increase of 10% of entire project time, use startDate instead of NOW): SELECT projNo, endDate, endDate + (1.1 * (endDate - NOW() DAYS)) DAYS AS "E…
-
Work experience is the Catch-22 of most positions - can't get a job without experience but can't get experience without a job. However, entry-level DBA jobs do come along, which would be what you'd want to start out. As to whether it's worth it, …
-
Work experience is the Catch-22 of most positions - can't get a job without experience but can't get experience without a job. However, entry-level DBA jobs do come along, which would be what you'd want to start out. As to whether it's worth it, …
-
Just making guesses at tables and columns for the first couple: 1) SELECT COUNT(*) FROM buildings WHERE parcel = '123' 2) SELECT parcelValue + buildingValue FROM (SELECT propertyValue AS parcelValue FROM parcels WHERE location = '55 Main Street…
-
Work experience is the Catch-22 of most positions - can't get a job without experience but can't get experience without a job. However, entry-level DBA jobs do come along, which would be what you'd want to start out. As to whether it's worth it, …
-
One possible way you can do this (assumes you want to add 10% to remaining time - if you want increase of 10% of entire project time, use startDate instead of NOW): SELECT projNo, endDate, endDate + (1.1 * (endDate - NOW() DAYS)) DAYS AS "E…
-
It's a real lame excuse for a game show, that's for sure...
-
It's a real lame excuse for a game show, that's for sure...
-
It's a real lame excuse for a game show, that's for sure...
-
It's a real lame excuse for a game show, that's for sure...
-
It's a real lame excuse for a game show, that's for sure...
-
It's a real lame excuse for a game show, that's for sure...
-
It's a real lame excuse for a game show, that's for sure...
-
It sounds like you prefer the design end of things rather than the nuts and bolts of coding...if so, you might consider moving towards systems analysis and design.