Programming in MS SQL Server 2012 |
CREATE Stored ProcedureThe following example describes CREATE PROCEDURE statement using the minimum required syntax. This example creates a stored procedure that returns all employees information. This procedure does not use any parameters. --
Example 98 -- USE EBusiness GO IF EXISTS (SELECT *
FROM
sysobjects
WHERE
name = N'dbo.usp_EmployeeList' AND
type = 'P')
DROP
PROCEDURE dbo.usp_EmployeeList GO
CREATE PROCEDURE dbo.usp_EmployeeList AS SELECT
EMP.Emp_Code,
EMP.Emp_Name,
EMP.DOJ,
EMP.Salary,
EMP.Dept_Code,
DEPT.Dept_Name FROM EMP INNER JOIN DEPT ON EMP.Dept_Code = DEPT.Dept_Code |
* * * * *