Re:The first rule of Microsoft Excel: Don’t tell anyone you’...
by somat on Tuesday October 25, 2022 @05:36AM
(#33328287)
Excel combines two things that most environments keep separate. storing data. and calculation/logic.
I have this theory that a relational database management system is basicly a grown up spreadsheet. and it is, it does great, far better that excel at storing and querying data. And you have better choices for logic, from views to full blown stored procedures(most will probably use an external program instead). all of which keep your logic out of your data.
I have this theory that a relational database management system is basicly a grown up spreadsheet. and it is, it does great, far better that excel at storing and querying data. And you have better choices for logic, from views to full blown stored procedures(most will probably use an external program instead). all of which keep your logic out of your data.