This is a discussion on Display Money Type using + and - within the SQL Server forums, part of the Microsoft SQL Server category; --> 1) Do not use the proprietary MONEY data type and its weird math in your schema.;You do Google ALL ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 1) Do not use the proprietary MONEY data type and its weird math in your schema.;You do Google ALL proprietary data types before you decide to destroy data integrity, portability, etc. in your schem? 2) Then you did wake up in the middle of a freshman class, so you woudl know that display is NEVER done in the database? You do know that in a tiered archtecture requires that display is done in the front end? Do this in the front end, where it is supposed to be!!! 3) Let's get back to the basics of an RDBMS. Rows are not records; fields are not columns; tables are not files; there is no sequential access or ordering in an RDBMS, so "first", "next" and "last" are totally meaningless. YOu have not learend the most basic concepts of RDBMS. Your whole mental/logical model is **totally wrong** and you need to stop programming because you are dangerously ignorant. My opinion is based on 20+ years of teaching SQL, writing standards, six books, and being paid to fix thing like this. |
| ||||
| CELKO, you need to save yourself some time and just setup an auto routine that emails new users as they come into the SQL group and tells them they are all retards. --CELKO-- wrote: > 1) Do not use the proprietary MONEY data type and its weird math in > your schema.;You do Google ALL proprietary data types before you decide > to destroy data integrity, portability, etc. in your schem? > > 2) Then you did wake up in the middle of a freshman class, so you woudl > know that display is NEVER done in the database? You do know that in a > tiered archtecture requires that display is done in the front end? Do > this in the front end, where it is supposed to be!!! > > 3) Let's get back to the basics of an RDBMS. Rows are not records; > fields are not columns; tables are not files; there is no sequential > access or ordering in an RDBMS, so "first", "next" and "last" are > totally meaningless. YOu have not learend the most basic concepts of > RDBMS. > > Your whole mental/logical model is **totally wrong** and you need to > stop programming because you are dangerously ignorant. My opinion is > based on 20+ years of teaching SQL, writing standards, six books, and > being paid to fix thing like this. |