Select * from musicCityContents
Select * from dbo.musicContents_tbl
sp_helptext music_setDefaultinfo
/*
작성자 : 한영민
작성일 : 2003-10-14
설 명 : 초기 musicCityContents 테이블에 데이터가 삽입 될때 사용되는 우리측 기본 정보 DB 생성
*/
ALTER PROCEDURE dbo.[music_setDefaultInfo]
@mc_Subject NVarchar(255),
@mc_Artist NVarchar(255),
@file_Code INT,
@genre NVarchar(32)
AS
Declare @IsCnt INT, @GenreIDX INT
SET XACT_ABORT ON
BEGIN TRANSACTION
Select @IsCnt = Count(*) , @GenreIDX = MAX(m_CD) From musicGenre_tbl Where m_GroupDesc = @genre
IF @IsCnt = 0 Begin
Insert musicGenre_tbl(m_GroupDesc, doID)
Values(@genre, 'system')
SET @GenreIDX = @@IDENTITY
End
IF @@Error <> 0 Begin
Goto Err
End
SET @IsCnt = 0
Select @IsCnt = Count(*) From musicContents_tbl Where file_code=@file_Code
IF @IsCnt = 0 Begin
Insert musicContents_tbl(mc_Subject, mc_Artist, m_CD, Rank, BuyCnt, giftCnt, ProposeCnt, askToBuyCnt, file_Code)
Values(@mc_Subject, @mc_Artist, @GenreIDX, 0, 0, 0, 0, 0, @file_Code)
IF @@Error <> 0 Begin
Goto Err
End
End
COMMIT TRANSACTION
Return 1
Err:
ROLLBACK TRANSACTION
Return 0
