Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
t1g312
Posting Yak Master
148 Posts |
 Posted - 2004-06-29 : 03:35:15
|
| Hi all,When saving/retrieving data, does it make more sense to format them (date etc) at the presentation layer (client) or database level (SPs)?Hope this isn't a stupid question.Adi-------------------------/me sux @sql server |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2004-06-29 : 07:38:39
|
| Definitely at the presentation layer, if it can handle it, that is. You'd want to avoid doing this at the database layer, simply because it is designed to store and retreive data, while presentation is a function of the UI layer and that is what it should do. Besides, it is a lot easier to format the presentation of data differently for different users, devices, pages, etc with the same data as long as it is handled at the front-end. if the database layer formats it, you are more or less stuck with the format then.OS |
 |
|
|
t1g312
Posting Yak Master
148 Posts |
Posted - 2004-06-29 : 08:56:35
|
quote:
Originally posted by mohdowais
Definitely at the presentation layer, if it can handle it, that is. You'd want to avoid doing this at the database layer, simply because it is designed to store and retreive data, while presentation is a function of the UI layer and that is what it should do. Besides, it is a lot easier to format the presentation of data differently for different users, devices, pages, etc with the same data as long as it is handled at the front-end. if the database layer formats it, you are more or less stuck with the format then.OS
Thanks for that!Adi-------------------------/me sux @sql server |
|
|
|
|
|
|
|
|
Formatting data