Calling SQL Server Stored Procedure
Posted: Thu Jun 05, 2008 8:24 pm
I have a SQL Server Stored Procedure that updates a table. The procedure has to be run for multiple rows and should return nothing.
How can I call SQL Server Stored Procedure and pass multiple rows as input?
Definition of Stored Procedure
USE [IBMDB]
GO
/****** Object: StoredProcedure [dbo].[IBMEDW_Update_Process] ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[IBMEDW_Update_Process]
@Interface_System char(3),
@Process_Type char(6),
@Process_Date datetime,
@Process_Flag char(1),
@Variables char(5)
AS
SET NOCOUNT ON
BEGIN
UPDATE DBO.IBM_PROCESS_INT SET
PROCESS_FLAG = @Process_Flag,
PROCESS_DATE = @Process_Date
WHERE INTERFACE_SYSTEM = @Interface_System
AND PROCESS_TYPE = @Process_Type
AND substring(VARIABLES,1,5) = @Variables
END
How can I call SQL Server Stored Procedure and pass multiple rows as input?
Definition of Stored Procedure
USE [IBMDB]
GO
/****** Object: StoredProcedure [dbo].[IBMEDW_Update_Process] ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[IBMEDW_Update_Process]
@Interface_System char(3),
@Process_Type char(6),
@Process_Date datetime,
@Process_Flag char(1),
@Variables char(5)
AS
SET NOCOUNT ON
BEGIN
UPDATE DBO.IBM_PROCESS_INT SET
PROCESS_FLAG = @Process_Flag,
PROCESS_DATE = @Process_Date
WHERE INTERFACE_SYSTEM = @Interface_System
AND PROCESS_TYPE = @Process_Type
AND substring(VARIABLES,1,5) = @Variables
END