Oct 14, 2008

delete with stored procedure in sqlserver

USE [RICH]
GO
/****** Object: StoredProcedure [dbo].[sp_deleteCohort] Script Date: 11/25/2008 09:53:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

CREATE PROCEDURE [dbo].[sp_deleteCohort]
@cohort as varchar(50)
AS
BEGIN
DELETE FROM RICHS2K8
WHERE
Cohort=@cohort
END

No comments: