As a guy about to finish up school and make his way into the work force, would y...

buckbova · on Oct 9, 2013

Try this quiz. It's based on a quiz I saw posted on HN a while back.

Edit: I'm not allowed to reply just yet, so I'll post here.

You need to add the boss first to the employee table with a NULL bossID.

Then you add another employee that has a bossID that refers to that last added record.

jsmeaton · on Oct 9, 2013

Aww - no test data? And when trying to add test data, I get errors due to the self-referencing foreign key. Perhaps the schema could do with a

> DEFAULT (IDENT_CURRENT('dbo.Employees'))

on the BossID column. Been awhile (years) since I've worked with SQL Server.

buckbova · on Oct 9, 2013

When the site is back up, I'll verify the link and post here. It's been about 2 months since I've used it.

Simple query stuff though.

Basic aggregate stuff. When to use "LEFT JOIN". Creating a scalar function. Multiple table JOINs.