Re: How can I conserve the initial zero when convert numeric to string using STR()
I think of it the other way round, surely the 5 applications would call 1
single query and not different queries for different applications.
SQL Server is more a service orientated architecture, well - becoming that
anyway.
So, doing things centrally in the SQL Server is better because you only need
do it once and not in 5 places in 5 different langauges requiring 6
different skill sets.
--
Tony Rogerson
SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson - technical commentary from a SQL
Server Consultant
http://sqlserverfaq.com - free video tutorials
"Anith Sen" <anith@bizdatas olutions.com> wrote in message
news:e5n83p$v6r $1@nntp.aioe.or g...[color=blue][color=green][color=darkred]
>>> Why on earth would you want to go to all the effort of using a 3GL / 4GL
>>> to format the data when you can just simply do it in TSQL within the SQL
>>> Server itself - nice and simple, nice and easy to support and maintain.[/color][/color]
>
> The general answer is that one would prefer to have the centralized
> database as generic as possible so that it can support a variety of
> applications.
>
> Having an application specific formatting at the central data source tend
> to generate something called "applicatio n bias". Considering the OP's
> question, given certain 5 applications requesting same data formatted in 5
> different ways, should he formulate a single generic query and do the
> formatting in the application or should he create 5 different queries to
> support each application? How about when the number of applications
> increases to 50? Or say 500?
>
> While it may appear to be efficient and easy to manage in the short term,
> it can often be highly detrimental to the long term stability and
> management of data centric systems.
>
> This is nothing new but such bias is known to software engineers for
> decades now. For details on why this separation of concern is important
> for data oriented systems, ~Principles of Program Design~ by Michael
> Jackson is a good book.
>
> --
> Anith
>[/color]
I think of it the other way round, surely the 5 applications would call 1
single query and not different queries for different applications.
SQL Server is more a service orientated architecture, well - becoming that
anyway.
So, doing things centrally in the SQL Server is better because you only need
do it once and not in 5 places in 5 different langauges requiring 6
different skill sets.
--
Tony Rogerson
SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson - technical commentary from a SQL
Server Consultant
http://sqlserverfaq.com - free video tutorials
"Anith Sen" <anith@bizdatas olutions.com> wrote in message
news:e5n83p$v6r $1@nntp.aioe.or g...[color=blue][color=green][color=darkred]
>>> Why on earth would you want to go to all the effort of using a 3GL / 4GL
>>> to format the data when you can just simply do it in TSQL within the SQL
>>> Server itself - nice and simple, nice and easy to support and maintain.[/color][/color]
>
> The general answer is that one would prefer to have the centralized
> database as generic as possible so that it can support a variety of
> applications.
>
> Having an application specific formatting at the central data source tend
> to generate something called "applicatio n bias". Considering the OP's
> question, given certain 5 applications requesting same data formatted in 5
> different ways, should he formulate a single generic query and do the
> formatting in the application or should he create 5 different queries to
> support each application? How about when the number of applications
> increases to 50? Or say 500?
>
> While it may appear to be efficient and easy to manage in the short term,
> it can often be highly detrimental to the long term stability and
> management of data centric systems.
>
> This is nothing new but such bias is known to software engineers for
> decades now. For details on why this separation of concern is important
> for data oriented systems, ~Principles of Program Design~ by Michael
> Jackson is a good book.
>
> --
> Anith
>[/color]
Comment