Hi,

You can try this approach:

Create a powershell script that zip the backup file. Here's the instruction.

Then create a widows task schedule with the powershell script. Here's the instruction. Or create...

Thanks Hugo.

I now understand NULL better and can conclude that NULL mark doesn't represent unknown data.

Hi Hugo,

I just want to double check my understanding about NULL. Please explain more why NULL does not mean "Unknown". I thought that NULL mark represents missing or unknown data.

In...

Very good explanation Hugo!

I like to think of it in sets of the table and use the properties of multiplication to simplify the problem.

So, for the qotd you have 1...

Good question. something different. I don't think ssc has many questions about row constructor.

ahhh those trailing spaces. 🙂 thanks for the question.

This scenario...

This is the easiest question of the month for me. Thanks. 😎

🙂 I lost track of...

m mcdonald (3/22/2013)

---

The way I read there are only 2 correct answers:

not 106,107,109,113

20,21

The answer, and included as a correct answer

Styles greater than 100

Cannot be correct because of the exceptions 106,107,109,113.

The...

I had to think twice about DDL and DML. Maybe it's better to not include (choose 3) in the question. this will make us think more. Otherwise people just use...

demonfox (3/21/2013)

---

Dineshbabu (3/20/2013)

---

Lokesh Vij (3/20/2013)

---

+1

same here. i feel...

I spent more time to figure out the values of orderdetailID than looking at the effect of the cascade delete. The question title can be misleading sometime. 😀

I never use...

Thanks for the question. I learned this precision rounding from March 12, inner join question from Archie Flockhart's comment. 🙂

That's correct. Convert...