proceduredemo3.sql

来自「T-SQL示例大全」· SQL 代码 · 共 22 行

/* 文件名称: ProcedureDemo3.sql */
USE 北风贸易
GO

if exists (select * from dbo.sysobjects where id = object_id(N'dbo.EmployeeByName') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure dbo.EmployeeByName
GO

CREATE PROCEDURE dbo.EmployeeByName
@name nvarchar(10)
AS
SELECT 身份证号码,
               姓名,
               出生日期,
               年龄 = DATEDIFF(yy,出生日期,GETDATE())
   FROM 飞狐工作室
   WHERE 姓名 = @name

GO