?! Of course it is.

is equivalent to:

Man SQL Server's designer tilts me sometimes. I wanted to change a column type from int to tinyint, all rows were null in that column. SQL Server refused to either do that or drop the column in the designer, because it claims those changes would result in the table having to be dropped and recreated. This was characterized as a "bug" by Microsoft back in SQL Server 2008 and still hasn't changed.

Agree with ChtisV and plexiq

Larry's question and subsequent debate about readability are interesting.

Using C, pretty sure (did not test it with actual code) this is equivalent to what plexiq coded with the if else if statements.

Seems easier to read to me.

Would bet substantial money you are the only person ITT who considers that easier to read. Well, there might be one or two others I guess.

Note: not having a go at you here.

^ Agreed, if you want to go ternary then this structure seems much more intuitive:

insert yodawgIheardyouliketernariessoweputternariesinyour ternariessonowyoucanternarywhileyouternary.gif

Eh I nest ternaries all the time and prettier unravels them

Why can't you slurp sql files into the command line, or even run raw SQL like normal database people?

****

IRT to ternary:

What do people who don't use ternary normally do (either by choice or by no language feature)? I've seen the fallout of that and it isn't pretty at all.

I'm not sure who's having a stroke here.

Is equivalent to

Is equivalent to:

I have coded quite a bit in ternaries (nested and non-nested). Two question marks in a row means nested if check. Two : in a row means exiting out of a nested block. Note, I am talking about JS. I know PHP's rules around ternaries aren't the same. I would need to surround any "nested" ternaries in () in order for them to be interpreted correctly. I'm guessing that is what's happening here.

Guy presenting to 10 people has an open tab googling for "depression". Yikes.

@Craggoo: Actually not sure what you are referring to, my post was regarding the "elseif is syntactic sugar for nested ifs" statement. I was merely showing that it's trivial to convert elseifs to nested ifs, so yes - they are indeed just syntactic sugar.

I was stating what the equivalent if/elseif/else blocks would look like for a couple ternary expressions if you went that route instead. Maybe we're talking about different things.

Yup, I always join video conferences from a new window just to avoid accidentally showing anything like that.

I even looked one time for a feature that was like incognito/private windows but not instead of not storing what you were doing, it would avoid using any personalization from your standard browsing (like url completion).

When I've done that I've just used a different browser. So for me I have chrome all customized and then for anything like this I use Firefox.

Though one time in a screen share coding challenge I went to cut and paste some code and the cut didn't take or something and I accidentally pasted in the link to some porn site...

old roommate was sharing and browsing hornymatches.com and mixed up his windows so everyone saw a half naked girl pop up on their screen. surprisingly he was not fired. he was working for a big consulting firm too.

Anyone here with embedded experience?

Adios? KatoKrazy? maybe others

From the above it sounds like half these guys are "embedded" in something during work hours.

I did some embedded stuff long ago, but in native assembly. I doubt that's how people do it now.

I do. Some things are easier in the designer, so sometimes I have that open and it would be nice if it would just do what I ask. It's not hard to write an ALTER COLUMN command, it's just annoying.

One of the best skills that carries over from sales to coding is presenting and leading demos. Our team lead was out a couple weeks ago so I took over demo responsibility for our sprint. The team thought it was the best demo we've had.

I have also researched options that are better than an incognito window but I feel pretty confident they don't exist.

At this point, I'm probably borderline too confident, but im always incredibly intentional in what I share from my screen/window to the point I would never disconnect from a remote monitor while sharing or anything that would alter the arrangement. Today, I was presenting and when things hit a lul and we were waiting for someone to go leave and get someone, I just instinctively used my phone to browse, knowing my machine was a no-touch zone.

I just had it ingrained into my head so hard from being on hundreds of conference calls and screen-share sessions.

On a similar vein, is there a good reason Oracle is completely different than every other database from the command line?

My backend teammates always want me to install a GUI whenever I do db stuff with them, but I just wanna use the command line, but Oracle doesn't have any of the same commands it seems like.

Oracle was developed in the 70s, predating everything we use today, plus the SQL standard by quite a few years.

PostgreSQL and MySQL have very different command lines as well. MySQL command line is borderline unusable.

Honestly my favorite command line from any database is probably sqlite3.

It's been a long time since I've used oracle, I always felt like using the command line tools was like programming in COBOL.

Typing War and Peace isn’t like coding in COBOL I can’t imagine a CLI that is even close.

Fun fact, my 35k posts are shorter than a CRUD app written in COBOL.

I do SOC design and verification. Sup?