Reputation
430
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 4 14
Newest
 Yearling
Impact
~34k people reached

  • 0 posts edited
  • 0 helpful flags
  • 13 votes cast
1d
comment T-SQL : Is string a Palindrome?
LTRIM(RTRIM(...)) whitespace?
Apr
21
awarded  Yearling
Apr
21
awarded  Nice Answer
Apr
19
answered If a person's name is Null then how would it break the database?
Mar
11
comment Windows to DB2 Connection: Connection authorization failure occurred. Reason: Local security service non-retryable error
Packaged as part of TSM (Tivoli Backup). Let me look into that.
Mar
11
comment Windows to DB2 Connection: Connection authorization failure occurred. Reason: Local security service non-retryable error
Added cfg information... and don't seem to see any activity on db2diag.log (or logs in /home/tsminst1/sqllib/db2dump/)
Mar
11
revised Windows to DB2 Connection: Connection authorization failure occurred. Reason: Local security service non-retryable error
added 9490 characters in body
Mar
11
asked Windows to DB2 Connection: Connection authorization failure occurred. Reason: Local security service non-retryable error
Nov
9
awarded  Popular Question
Aug
31
awarded  Famous Question
Jan
29
revised Alternative to RDBMS: Modeling Exam/Testing data
added 70 characters in body
Jan
29
asked Alternative to RDBMS: Modeling Exam/Testing data
Dec
23
comment Does DB2 order data by the primary key
Yeah, that's why I was +1 for IBM docs over "Standards". "Expected" vs "Actual" can, and most definitely will, bite you in the keister.
Dec
23
comment Does DB2 order data by the primary key
"If they behave by SQL standards" is a big if... IBM docs FTW.
Jul
2
awarded  Curious
Jun
26
awarded  Notable Question
May
2
awarded  Nice Question
Feb
5
accepted Good, Bad or Indifferent: WHERE 1=1
Dec
15
comment Why use WHERE 1 or WHERE 1=1?
I write code similar to the first block in SSMS or similar query tools. Researching data sets and getting the right results before it gets put into reporting tools (like Crystal Reports) for end users. The second block is what I've seen other people do, since my job hasn't been too much about raw sql access. I've troubleshot other peoples similar code and can understand the reasoning. (Code was in VB, C# and PHP).
Dec
13
answered Why use WHERE 1 or WHERE 1=1?