|
|
USE [colombo]
GO
IF EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[sp_efact_add]')
AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_efact_add]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/* =====================================================
Author: [ amper ]
Create date: [ 20070111 ]
Description: [ add record to EmployeeFacts table ]
======================================================= */
CREATE PROCEDURE [dbo].[sp_efact_add]
@empno INT = 0
@fact nvarchar(200)
AS
BEGIN
-- insert fact if Employee number exists
IF EXISTS (SELECT * FROM Employees
WHERE EmpNo = @empno)
BEGIN
INSERT INTO EmployeeFacts (EmpNo,fact,createdate)
VALUES (@empno,@fact,GetDate());
END
END
GO
GRANT EXECUTE ON OBJECT::[dbo].[sp_efact_add]
TO george;
GO
|
|