Re: need information for "Before Select" Trigger
- From: "Lucky" <tushar.n.patel@xxxxxxxxx>
- Date: 8 Jun 2006 07:13:08 -0700
Hi Pal,
i did the same way but as i said i'm using .net 2.0's dataset which
seems doesnt understands the view. As i've added "Enforced Constraints"
in the Dataset, may be that could not allowed the View to be considered
with foriegn key, unique value, not null constraint.
to avoid this situation i need to some other way. and yes it is true.
i'm reffering it in more then 20 webpages so i cant modifiy it.
anyways thanks for help.
Lucky
Erland Sommarskog wrote:
Lucky (tushar.n.patel@xxxxxxxxx) writes:
Currently i'm facing a bit odd situation. i cant modify my code so i
have to make changes in SQL Server.
the problem is, i've modified one table by adding new column and now i
want only those row which has not null value in that column whenever
the select statement gets fire. i mean in every select statement only
those rows should be returned which has NOT NULL value in the newly
added column.
for this i've created one view and tried to run the application but the
i'm facing some problem as my application is developed in .net 2.0,
i've used lots of .net functionalities and now i cant make any changes
in Code.
another solution i think is triggers. if i can fire a trigger before
any select statements, my problem can be solved instantly but i'm
afraid i can not write andy "before select" trigger.
There are no BEFORE SELECT triggers. (In fact, there are no BEFORE triggers
at all in SQL Server.)
The way to handle this would be define a view, which includs a filter on
this column.
However, personally, I would not add a view for such a simple condition,
but rather add it as needed.
If you real problem is that this table is referred to in lots of places
(lots => more than 20), and you want this column to take effect every
where, you could renamed the table, and then create a view with that
carries on the original name of the table.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: need information for "Before Select" Trigger
- From: Erland Sommarskog
- Re: need information for "Before Select" Trigger
- From: David Portas
- Re: need information for "Before Select" Trigger
- References:
- need information for "Before Select" Trigger
- From: Lucky
- Re: need information for "Before Select" Trigger
- From: Erland Sommarskog
- need information for "Before Select" Trigger
- Prev by Date: Log Explorer vs. ApexSQL Log vs. SQL Log-Rescue
- Next by Date: noob sql learn! web interface and sql express!
- Previous by thread: Re: need information for "Before Select" Trigger
- Next by thread: Re: need information for "Before Select" Trigger
- Index(es):
Relevant Pages
|
