Stored procedure if statement - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Stored procedure if statement

Author

Topic

programer
Posting Yak Master

221 Posts

Posted - 2012-01-13 : 03:38:39

CREATE PROCEDURE dbo.PaymentTypeBank_Insert

@UserId uniqueidentifier OUTPUT,
@PaymentType nvarchar(50),
@IsDeleted bit = false,
@IsBlocked bit = false,
@IBAN nvarchar(150),
@SWIFT nvarchar(150),
@BANKNAME nvarchar(150)

AS

INSERT INTO dbo.tbl_PaymentType
(UserId,
PaymentType,
IsDeleted,
IsBlocked)
VALUES (@UserId,
@PaymentType,
@IsDeleted,
@IsBlocked)

DECLARE @PaymentTypeID int
SET @PaymentTypeID = CAST(SCOPE_IDENTITY() AS INT)

INSERT INTO dbo.tbl_PaymentDetails (
PaymentTypeID,
AttributeName,
Value )
VALUES

( @PaymentTypeID, 'IBAN', @IBAN),
( @PaymentTypeID, 'SWIFT', @SWIFT),
( @PaymentTypeID, 'BANKNAME', @BANKNAME)

If I stored PaymentType = "Bank" i want to use INSERT INTO dbo.tbl_PaymentDetails.

How to get this?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-01-13 : 03:58:30

just add a if condition like


...
IF (SELECT PaymentType FROM dbo.tbl_PaymentType WHERE PaymentTypeID=@PaymentTypeID) = 'Bank'
BEGIN 
INSERT INTO dbo.tbl_PaymentDetails ( 
PaymentTypeID, 
AttributeName, 
Value )
VALUES 


( @PaymentTypeID, 'IBAN', @IBAN),
( @PaymentTypeID, 'SWIFT', @SWIFT),
( @PaymentTypeID, 'BANKNAME', @BANKNAME)


END

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources