SQL window functions provide extremely powerful and useful features that let you work with observations more easily. Different types explained here.

Maybe this is a strange question, but is there a way to add a single row (or several) to the return set of a SELECT statement?Example:I want to populate a drop down list with SELECT EmpID ...

Coming up to speed with other database management systems and Microsoft's own SQL Azure, row level security is now available in SQL Server.