Returning The Value Of A Generated Key On Insert In MSSQL

I wanted to use GUIDs for a specific table's primary key, but I had no intention of running two queries just so I could get the newly created row's GUID. Here's a great way to get data created within a stored procedure back to the code that called it.