Click here to Skip to main content
15,991,949 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: Linux C PreProcessor: Who Knew? Pin
raddevus9-Jul-24 4:51
mvaraddevus9-Jul-24 4:51 
GeneralDoes this scare anyone else? Pin
honey the codewitch4-Jul-24 0:44
mvahoney the codewitch4-Jul-24 0:44 
GeneralRe: Does this scare anyone else? Pin
Peter_in_27804-Jul-24 11:33
professionalPeter_in_27804-Jul-24 11:33 
GeneralRe: Does this scare anyone else? Pin
honey the codewitch4-Jul-24 11:35
mvahoney the codewitch4-Jul-24 11:35 
GeneralWhat the hell GCC, again Pin
k50542-Jul-24 11:32
mvek50542-Jul-24 11:32 
GeneralRe: What the hell GCC, again Pin
Brisingr Aerowing13-Aug-24 15:16
professionalBrisingr Aerowing13-Aug-24 15:16 
GeneralDynamic SQL Pin
Richard Andrew x6430-Jun-24 9:43
professionalRichard Andrew x6430-Jun-24 9:43 
GeneralRe: Dynamic SQL Pin
raddevus30-Jun-24 12:47
mvaraddevus30-Jun-24 12:47 
Richard Andrew x64 wrote:
So even something as weird and wonderful as that has a use.

i think you are being far too generous & kind.

It's a terrible idea for numerous reasons. I know little about DBs & DBMS but there are a couple that seem glaringly wrong to me:

1) one of the big ideas of a SP is that it is precompiled. This build-string-query then exec would insure that wouldn't be true. Think about that. A SP is precompiled & knows the "execution path" but in this case that would never be true, so it makes entire no sense that this "dynamic" thing would be a SP.
2) built in query analyzer of SQL Server would not know what the execution would be & this probably causes performance issues & the inability to know if it is slow or not since the query is built on the fly

I'm going to assume that some dev with little experience got this "genius" idea for how to create dynamic queries and no one ever looked at it because "it works".

SQL Server is an amazing feat of true Engineering and will fix things for you so the dev is probably getting really lucky.
Plus hardware is probably handling this.
And probably if the thing really got serious traffic it would bog down to nothing.

Just another Lucky Dev -- they're 92% of all Devs anyways.

"That's not coding, that's typing." Roll eyes | :rolleyes:
GeneralRe: Dynamic SQL Pin
Richard Deeming30-Jun-24 21:36
mveRichard Deeming30-Jun-24 21:36 
GeneralRe: Dynamic SQL Pin
PIEBALDconsult30-Jun-24 17:50
mvePIEBALDconsult30-Jun-24 17:50 
GeneralRe: Dynamic SQL Pin
Shane010330-Jun-24 18:07
Shane010330-Jun-24 18:07 
GeneralRe: Dynamic SQL Pin
raddevus1-Jul-24 2:11
mvaraddevus1-Jul-24 2:11 
GeneralRe: Dynamic SQL Pin
Daniel Pfeffer30-Jun-24 19:17
professionalDaniel Pfeffer30-Jun-24 19:17 
GeneralRe: Dynamic SQL Pin
Richard Deeming30-Jun-24 21:31
mveRichard Deeming30-Jun-24 21:31 
GeneralRe: Dynamic SQL Pin
Pete O'Hanlon30-Jun-24 21:45
mvePete O'Hanlon30-Jun-24 21:45 
GeneralRe: Dynamic SQL Pin
jochance2-Jul-24 7:14
jochance2-Jul-24 7:14 
GeneralRe: Dynamic SQL Pin
Sander Rossel9-Jul-24 1:05
professionalSander Rossel9-Jul-24 1:05 
GeneralHow, VS Code? This is amazing. Pin
honey the codewitch22-Jun-24 14:51
mvahoney the codewitch22-Jun-24 14:51 
GeneralRe: How, VS Code? This is amazing. Pin
Richard Andrew x6423-Jun-24 4:32
professionalRichard Andrew x6423-Jun-24 4:32 
GeneralRe: How, VS Code? This is amazing. Pin
honey the codewitch23-Jun-24 4:35
mvahoney the codewitch23-Jun-24 4:35 
GeneralRe: How, VS Code? This is amazing. Pin
Richard Andrew x6423-Jun-24 4:45
professionalRichard Andrew x6423-Jun-24 4:45 
GeneralRe: How, VS Code? This is amazing. Pin
honey the codewitch23-Jun-24 4:46
mvahoney the codewitch23-Jun-24 4:46 
GeneralRe: How, VS Code? This is amazing. Pin
Dave Kreskowiak23-Jun-24 6:11
mveDave Kreskowiak23-Jun-24 6:11 
GeneralRe: How, VS Code? This is amazing. Pin
Luschan25-Aug-24 19:32
Luschan25-Aug-24 19:32 
GeneralWhat the hell gcc? Pin
honey the codewitch17-Jun-24 21:20
mvahoney the codewitch17-Jun-24 21:20 

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.