Which SQL Server Service Pack do I have?

Question: How can I tell which Service Pack is installed on my SQL Server?

Answer: The ServicePack that is installed can be recognized in the SQLServer version number.