SQL Server often provides several ways to accomplish a task. To choose the best technique for your situation, it helps to brush up on the differences between various options. In this series, I compare and contrast some similar SQL Server features that I'm often asked about. This month, I compare user-defined functions (UDFs) with stored procedures and HAVING clauses with WHERE clauses. Enjoy the article and please send questions or topics you'd like me to cover to pinal@SQLAuthority.com. I look forward to your feedback!