Re: Avoid update without where clause
From: Donald (anonymous_at_discussions.microsoft.com)
Date: 05/27/04
- Next message: Steve Z: "RE: How do people use SQL in Win authenticated mode only?"
- Previous message: anonymous_at_discussions.microsoft.com: "Re: Missing table"
- In reply to: Aaron Bertrand - MVP: "Re: Avoid update without where clause"
- Next in thread: Keith Kratochvil: "Re: Avoid update without where clause"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 27 May 2004 10:51:21 -0700
Good answer, i like the sledgehammer example
Thank you
>-----Original Message-----
>No, this is a case where your developers must use common
sense, and look
>over their scripts before executing them.
>
>If it's any consolation, SQL Server also won't prevent
you from tripping
>over the power cord or using a sledgehammer against the
CPU. ;-)
>
>--
>Aaron Bertrand
>SQL Server MVP
>http://www.aspfaq.com/
>
>
>
>
>"Donald" <anonymous@discussions.microsoft.com> wrote in
message
>news:1383601c443ff$12727930$a001280a@phx.gbl...
>> Hi every one,
>>
>> Using SQL 7.0,
>>
>> Without using transaction, is there a way that SQL void
>> (refuse) any update or delete if there is no where
>> clause ?
>>
>> In order to avoid devastating lapse of memory :o\
>>
>> Thanks !
>>
>> Donald
>
>
>.
>
- Next message: Steve Z: "RE: How do people use SQL in Win authenticated mode only?"
- Previous message: anonymous_at_discussions.microsoft.com: "Re: Missing table"
- In reply to: Aaron Bertrand - MVP: "Re: Avoid update without where clause"
- Next in thread: Keith Kratochvil: "Re: Avoid update without where clause"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
