CREATE TABLE [dbo].[BANKASTART](

[Char] [smallint] NULL,

[WareHouseData] [varchar](1600)NULL,

) ON [PRIMARY]

GO

INSERT INTO BANKASTART VALUES (1,NULL)

PROSEDÜRÜ EKLEYELİM

Kod:
USE [Kn_online]

GO

/****** Object:  StoredProcedure [dbo].[StartBanka]    Script Date: 08/23/2010 19:36:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[StartBanka]

@AccountID    char(21)

AS

--Yazan ve Cizen: RootC

--ko-fox.Com

DECLARE @row varchar(1600)

SET @row = null

SELECT @row = WareHouseData FROM WAREHOUSE WHERE strAccountID = @AccountID

IF @row IS null

BEGIN

update WAREHOUSE set WarehouseData = ( select WarehouseData from BANKASTART where Char = '1' )

where strAccountID = @AccountID

END

Create_New_Char Prosedürünü açın ve en alta inin Maviyle yazan kodu buLun ve aşağıdaki kırmızı iLe yazan kodu ekLeyin;

Kod:
IF @@ERROR <> 0

BEGIN

ROLLBACK TRAN

SET @nRet = 4

RETURN

END

COMMIT TRAN

SET @nRet = 0

Kod:
EXEC StartBanka @AccountID