Viewing 15 posts - 4,126 through 4,140 (of 6,026 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...
February 19, 2015 at 7:33 am
Grant Fritchey (2/19/2015)
shane.green 1227 (2/19/2015)
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...
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...
February 18, 2015 at 11:37 am
butcherking13 (2/18/2015)
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...
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...
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...
February 17, 2015 at 4:03 pm
GoofyGuy (2/17/2015)
I'm tempted to make a comparison between American...
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:...
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...
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...
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...
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...
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...
February 17, 2015 at 6:23 am
Viewing 15 posts - 4,126 through 4,140 (of 6,026 total)