Click here to Skip to main content
15,888,968 members

The Weird and The Wonderful

   

The Weird and The Wonderful forum is a place to post Coding Horrors, Worst Practices, and the occasional flash of brilliance.

We all come across code that simply boggles the mind. Lazy kludges, embarrassing mistakes, horrid workarounds and developers just not quite getting it. And then somedays we come across - or write - the truly sublime.

Post your Best, your worst, and your most interesting. But please - no programming questions . This forum is purely for amusement and discussions on code snippets. All actual programming questions will be removed.

 
GeneralRe: for(int i=0; i<size; i++) Pin
peterchen6-May-13 2:58
peterchen6-May-13 2:58 
GeneralRe: for(int i=0; i<size; i++) Pin
DanielSheets6-May-13 7:12
DanielSheets6-May-13 7:12 
GeneralRe: for(int i=0; i<size; i++) Pin
DerekT-P8-May-13 0:26
professionalDerekT-P8-May-13 0:26 
Generalwhile(life!=death) Pin
Bikash Prakash Dash11-May-13 5:03
Bikash Prakash Dash11-May-13 5:03 
GeneralRe: for(int i=0; i<size; i++) Pin
Peter Josefsson Sweden19-May-13 23:58
Peter Josefsson Sweden19-May-13 23:58 
GeneralRe: for(int i=0; i<size; i++) Pin
John Hunley29-May-13 8:46
John Hunley29-May-13 8:46 
GeneralRe: for(int i=0; i<size; i++) Pin
MacSpudster31-May-13 9:54
professionalMacSpudster31-May-13 9:54 
GeneralInteresting Observation Pin
virang_2129-Apr-13 14:45
virang_2129-Apr-13 14:45 
I was looking at one old SQL stored proc and found this strange behaviour.

SQL
DECLARE @Scrap_Qty int
DECLARE @FilledQty int
SET @Scrap_Qty=10 --Change this to 1 and it still run
SET @FilledQty = 2

BEGIN

IF @Scrap_Qty  > @FilledQty
 declare @currDate varchar(10)   
 Set @currDate= Convert(VARCHAR(10),GetDate(),103)  
 PRINT @currDate

END  


Look at the if condition .. it does not have BEGIN..END... To make thing interesting weather if condition is true or false you will get the output for parameter @currDate

If I add PRINT @Scrap_Qty right after IF and run it again it will only print value for @Scrap_Qty if condition is true. Which leads to question why sql is not complaining about undeclared variable if @Scrap_Qty is less than @FilledQty ?

I would have assumed if condition without BEGIN .. END block will behave like a normal one line to execute if condition is true which in above block is declaration of @currDate variable.

SQL
DECLARE @Scrap_Qty int
DECLARE @FilledQty int
SET @Scrap_Qty=10 --Change this to 1 and it won't output @Scrap_Qty
SET @FilledQty = 2

BEGIN

IF @Scrap_Qty  > @FilledQty
	PRINT @Scrap_Qty
 declare @currDate varchar(10)   
 Set @currDate= Convert(VARCHAR(10),GetDate(),103)  
 PRINT @currDate

END  

Zen and the art of software maintenance : rm -rf *

Math is like love : a simple idea but it can get complicated.

GeneralRe: Interesting Observation Pin
Pablo Aliskevicius29-Apr-13 19:47
Pablo Aliskevicius29-Apr-13 19:47 
GeneralRe: Interesting Observation Pin
agolddog1-May-13 3:42
agolddog1-May-13 3:42 
GeneralRe: Interesting Observation Pin
Raja Sekhar S5-Jun-13 21:14
Raja Sekhar S5-Jun-13 21:14 
GeneralRe: Interesting Observation Pin
Pablo Aliskevicius5-Jun-13 21:21
Pablo Aliskevicius5-Jun-13 21:21 
GeneralRe: Interesting Observation Pin
Raja Sekhar S5-Jun-13 22:05
Raja Sekhar S5-Jun-13 22:05 
GeneralRe: Interesting Observation Pin
Pablo Aliskevicius5-Jun-13 23:31
Pablo Aliskevicius5-Jun-13 23:31 
GeneralRe: Interesting Observation Pin
Raja Sekhar S5-Jun-13 23:39
Raja Sekhar S5-Jun-13 23:39 
GeneralNot 'Clap' but 'CLAP', dammit. Pin
Brady Kelly24-Apr-13 22:36
Brady Kelly24-Apr-13 22:36 
GeneralRe: Not 'Clap' but 'CLAP', dammit. Pin
dusty_dex24-Apr-13 23:19
dusty_dex24-Apr-13 23:19 
GeneralRe: Not 'Clap' but 'CLAP', dammit. Pin
Brady Kelly24-Apr-13 23:33
Brady Kelly24-Apr-13 23:33 
GeneralRe: Not 'Clap' but 'CLAP', dammit. Pin
H.Brydon25-Apr-13 14:59
professionalH.Brydon25-Apr-13 14:59 
GeneralRe: Not 'Clap' but 'CLAP', dammit. Pin
Brisingr Aerowing25-Apr-13 1:16
professionalBrisingr Aerowing25-Apr-13 1:16 
GeneralRe: Not 'Clap' but 'CLAP', dammit. Pin
Brady Kelly25-Apr-13 2:56
Brady Kelly25-Apr-13 2:56 
GeneralRe: Not 'Clap' but 'CLAP', dammit. Pin
hvanzyll26-Apr-13 5:26
hvanzyll26-Apr-13 5:26 
GeneralRe: Not 'Clap' but 'CLAP', dammit. Pin
Rob Grainger1-May-13 3:23
Rob Grainger1-May-13 3:23 
GeneralProduction code adds a BCC to email account of developer Pin
0bx24-Apr-13 5:48
0bx24-Apr-13 5:48 
AnswerRe: Production code adds a BCC to email account of developer Pin
AspDotNetDev24-Apr-13 5:54
protectorAspDotNetDev24-Apr-13 5:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.