SQL Server: SPs and UDFs
The reason for having both stored procedures and functions in SQL Server, and the differences between them:
From builder.com.com: SQL Server 2000's user-defined functions add flexibility, cut coding time.
Question from experts-exchange.com: Difference between Stored-Procedure and Function.
And, turned up by my search yet completley un-related, a list of sample SQL Server interview questions. I think a lot of them are scarily simple, but maybe that's just me.... ? techinterviews.com.
