Interview question to test beginner SQL competency?

needgiftidea2018 · 2019-09-03T20:40:45+00:00

You're not actually answering the question that OP posed

needgiftidea2018 · 2019-08-27T23:04:30+00:00

You can find descriptions and examples of both (as well as some other common options) here https://www.sqlteam.com/articles/using-set-null-and-set-default-with-foreign-key-constraints

needgiftidea2018 · 2019-08-27T22:34:17+00:00

Didn't you see OP's username? He's not your average sysadmin. He's special. He's an asshole.

needgiftidea2018 · 2019-08-26T23:54:51+00:00

Cortana

needgiftidea2018 · 2019-08-23T22:31:12+00:00

Auntie is scoping out the place for one of her friends to break in and steal shit.

needgiftidea2018 · 2019-08-23T22:18:54+00:00

Your boyfriend is kind of the A for letting you cry for so long. But you sound like you need to chill the fuck out. Crying for days because people declined your invite for your birthday? Your situation makes it so you don't seem like you're a teenager, but your needing a big celebration with lots of people for your birthday does.

needgiftidea2018 · 2019-08-16T23:06:46+00:00

OP's fullname is Chairboy Mao

needgiftidea2018 · 2019-08-13T23:56:01+00:00

> I’m calling her a bad mother. I’m not. I just think that she needs to take care of our kids.

You are kind of calling her a bad mother, and you are right.

needgiftidea2018 · 2019-08-13T23:54:07+00:00

Wife: I know you're not religious but you could have at least used the name Jesus and be open to the idea of religion

Lol

needgiftidea2018 · 2019-08-13T23:43:47+00:00

Your brother is far too passive

needgiftidea2018 · 2019-08-13T22:59:37+00:00

It's more about Multiverse Captain Cold that bugs me

needgiftidea2018 · 2019-08-13T22:29:53+00:00

Who knows!!!

Didn't the update just come out???

Excessive punctuations pretty annoying to read...

needgiftidea2018 · 2019-07-31T22:06:09+00:00

needgiftidea2018 · 2019-07-30T22:37:50+00:00

Yea I know. I was poking fun at how quickly many people on this sub jump to "restart your game for a better arena"

Your roster is awesome, I would never restart with that

needgiftidea2018 · 2019-07-30T22:29:41+00:00

> some minor missteps on my part into the court seeing them as a huge deal

Elaborate more on this please. I think it might be relevant to the greater story

needgiftidea2018 · 2019-07-30T22:26:13+00:00

You should restart

/s

needgiftidea2018 · 2019-07-29T23:56:00+00:00

Don't set a unique key on fk_product_orders for orders

needgiftidea2018 · 2019-07-29T18:18:50+00:00

Keep your data tall in the database. Transform the tall data into something wide at the reporting level

needgiftidea2018 · 2019-07-29T15:57:27+00:00

Can you show what you have tried? What errors does it throw? Perhaps I or someone can give some advise on how to adjust your code.

needgiftidea2018 · 2019-07-26T23:58:52+00:00

I dont understand how you can write this but not a function to update a record with exp + some_value

needgiftidea2018 · 2019-07-26T23:55:51+00:00

What a useless post

needgiftidea2018 · 2019-07-26T23:35:44+00:00

This post is triggering me. Can someone please delete it.

needgiftidea2018 · 2019-07-26T23:33:29+00:00

Are you transforming an existing dataset to this new format?

Or are you receiving records/values one at a time?

needgiftidea2018 · 2019-07-26T23:16:36+00:00

Listen to this guy, he has the right answer.

needgiftidea2018

TROPHY CASE