SQL Server: Restore DB with alter and restore in a since query

restore.sql

USE [master]
alter database [databaseName]
set single_user with rollback immediate
GO

RESTORE DATABASE [databaseName] FROM DISK = 'path\to\db\backup.bak' 
WITH REPLACE
GO

alter database [databaseName]
set multi_user with rollback immediate
GO

--http://screencast.com/t/CBubnbnOb6X



-- example
USE [master]
alter database exeterHospital
set single_user with rollback immediate
GO

RESTORE DATABASE exeterHospital FROM DISK = 'C:\_DB_Backups\exeterHospital.bak' 
WITH REPLACE
GO

alter database exeterHospital
set multi_user with rollback immediate
GO