You shouldn't need to stop the service to apply a service pack. The patch should do this for you, but it doesn't hurt.
To stop the services, open the services applet from the start menu (in control panel). Find the SQL Server service, which might have a name for named instances, select the service and click stop.
24 People are following this question.