Viewing 15 posts - 4,141 through 4,155 (of 6,041 total)
If you choose to compare a column to itself, then understand that it's not functionally the same as "1 = 1", the result will exclude rows with NULL values.
create...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 19, 2015 at 7:33 am
Grant Fritchey (2/19/2015)
shane.green 1227 (2/19/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 19, 2015 at 7:18 am
Eric M Russell (2/18/2015)
Resender (2/2/2015)
I always do
WHERE 1 = 1
I can't remember where I picked this habit up...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 18, 2015 at 12:28 pm
Resender (2/2/2015)
I always do
WHERE 1 = 1
I can't remember where I picked this habit up and I'm one...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 18, 2015 at 11:37 am
butcherking13 (2/18/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 18, 2015 at 11:19 am
djackson 22568 (2/18/2015)
...
It is also against the law to kill and steal, but people do it. Laws don't prevent anything, they discourage. Governments and corporations across the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 18, 2015 at 7:53 am
call.copse (2/18/2015)
Eric M Russell (2/17/2015)
GoofyGuy (2/17/2015)
It eliminates the need to eat.Liquid bread, it is!
Which makes we wonder: Maybe Brits do have better beer options in a typical bar, but...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 18, 2015 at 7:32 am
GoofyGuy (2/17/2015)
It eliminates the need to eat.Liquid bread, it is!
Which makes we wonder: Maybe Brits do have better beer options in a typical bar, but how does the bar...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 17, 2015 at 4:03 pm
GoofyGuy (2/17/2015)
I'm tempted to make a comparison between American...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 17, 2015 at 3:58 pm
But are most data breaches the result of SQL injection or even ad-hoc database access by outsiders?
From what I've seen, most of these massive data breaches are done by:...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 17, 2015 at 11:22 am
Kev Charlatan (2/17/2015)
'Use it carefully'Understatement of the year!
Yeah, you definately want to first test fire it on the development server a few times just to make sure you know how...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 17, 2015 at 10:42 am
However there are two big problems that prevent us from eradicating SQL Injection: aging code and bad habits.
I know it gets old, but we should never assume we're preaching...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 17, 2015 at 10:29 am
This would be more of a solution going forward, but we can also use DDL Triggers to audit all database schema changes. I've personally never done this, but as the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 17, 2015 at 7:21 am
aaron.reese (2/17/2015)
Currently have 40+ customers all with modified databases that do not match the release standard and the test database may or may not match the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 17, 2015 at 7:10 am
Igor Micev (2/16/2015)
bgrossnickle (2/10/2015)
won't you get an error if you try to kill system processes?
This is a good notice. System databases' process should be avoided.
@author: What about if you want...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 17, 2015 at 6:23 am
Viewing 15 posts - 4,141 through 4,155 (of 6,041 total)