quote:

---

CREATE PROC dbo.spRaceInfo
@UpdateType AS char(6),
@RaceID AS int = NULL,
@SectionID AS smallint = NULL,
@RaceName AS varchar(50) = NULL,
@ImagePath AS varchar(50) = NULL,
@RaceDescription AS varchar(MAX) = NULL
AS

SET NOCOUNT ON;
SET XACT_ABORT ON;

BEGIN TRY
BEGIN TRANSACTION;

--Process a new race
IF (@UpdateType = 'Insert')
BEGIN
INSERT INTO dbo.RaceInfo (SectionID, RaceName, ImagePath, RaceDescription)
VALUES (@SectionID, @RaceName, @ImagePath, @RaceDescription);

EXEC dbo.spAddSectionMenuItem @SectionID, 'Info', 'Races', 'Races', 'Race Information';

INSERT INTO dbo.SiteUpdates (UpdatedSectionID, UpdatedSubSectionName, UpdatedItemName, UpdateType)
VALUES (@SectionID, 'Races', @RaceName, @UpdateType);
END
ELSE IF (@UpdateType = 'Update')
--Process a race update
BEGIN
UPDATE dbo.RaceInfo
SET SectionID = @SectionID,
RaceName = @RaceName,
ImagePath = COALESCE(@ImagePath, ImagePath),
RaceDescription = @RaceDescription
WHERE RaceID = @RaceID;

INSERT INTO dbo.SiteUpdates (UpdatedSectionID, UpdatedSubSectionName, UpdatedItemName, UpdateType)
VALUES (@SectionID, 'Races', @RaceName, @UpdateType);
END
ELSE IF (@UpdateType = 'Delete')
--Process race removal
BEGIN
DELETE dbo.RaceInfo
WHERE RaceID = @RaceID;
END

COMMIT

END TRY

BEGIN CATCH

IF ((XACT_STATE()) = -1)
BEGIN
ROLLBACK;
END
ELSE IF ((XACT_STATE()) = 1)
BEGIN
COMMIT;
END

END CATCH

---

quote:

---

Originally posted by visakh16

code looks fine to me

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

---