SQL Server Stored Procedure Example

use Halloween;
go

create procedure dbo.SelectEmployees
as
begin;
select * from dbo.Employee;
end;

exec dbo.SelectEmployees;