Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1539

Re: "Parameterized" Views - really that ugly?

Show all headers | View raw

On 07/28/2013 09:28 PM, Bob Barrows wrote:
> Ulrich Achilles wrote:
>> (@somedate is a monday and the view selects the courses that are
>> actual for that week).
>>
>> Of course I found soon that it is not possible to pass parameters to a
>> view in SQL server.
>
> An Access parameterized view is exactly the same as a simple SQL Server
> stored procedure, except the procedure is not directly updatable. That,
> however. is not a great loss since there is no frontend to SQL Server that
> does everything that Access does for Jet databases. The front end for a SQL
> Server database needs to provide all the functions provided by Access. This
> typically means retrieving read-only data from the database (to avoid
> locking problems) and passing parameter values to a stored procedure that
> performs updates, inserts and deletions as needed.
>
>> As a solution I created a table "parameters" with
>> just one row to hold the parameter and joined it to the courses-table:
>>
>> I came across that construction in the net, but it was commented as
>> horrible, ugly and so forth.
>>
>> My question: Is it really that bad? And why?
>
> Yes, it can be. There are so many things that can cause problems.
> Client crashes can leave bad parameter values in the table.
> Multiple users can be using each other's incorrect parameter values.
> Mainly, it's bad because it's outside of the developer's control (assuming
> that users are entering values into it).
>
>
>
Hallo,

thank you very much for your helpful explanations.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

"Parameterized" Views - really that ugly? Ulrich Achilles <uli.achilles@googlemail.com> - 2013-07-28 11:30 +0200
  Re: "Parameterized" Views - really that ugly? "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2013-07-28 15:28 -0400
    Re: "Parameterized" Views - really that ugly? Ulrich Achilles <uli.achilles@googlemail.com> - 2013-07-30 09:31 +0200

csiph-web