Führ das aus, sollte reichen.
Code:
USE [CHARACTER_01_DBF]
GO
/****** Object: StoredProcedure [dbo].[usp_GuildFurniture_Log] Script Date: 04/03/2010 12:42:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
/*============================================================
1. ??? : ???
2. ??? : 2009.11.23
3. ???? ? : usp_GuildFurniture_Log
4. ???? ?? : ?? ??? ?? Log ??
5. ????
@serverindex char(2) ???
@m_idGuild char (6) ?????
@SEQ int SEQ ( 0 ??? GuildHouse ? ???? ?? ?? ?)
6. ???
7. ?? ??
8. ?? ?? ??
EXEC usp_GuildFurniture_Log '05', '123456'
9. ?? ? ident ? ???
select * from tblGuildHouse_FurnitureLog
delete tblGuildHouse_FurnitureLog
============================================================*/
CREATE proc [dbo].[usp_GuildFurniture_Log]
@serverindex char(2),
@m_idGuild char (6),
@SEQ int = 0
as
set nocount on
set xact_abort on
if @SEQ = 0
begin
-- EXEC(' insert into LOG_' + @serverindex + '_DBF.dbo.tblGuildHouse_FurnitureLog
EXEC(' insert into LOGGING_01_DBF.dbo.tblGuildHouse_FurnitureLog
(
serverindex, m_idGuild, SEQ, ItemIndex, bSetup, s_date, set_date
)
SELECT serverindex, m_idGuild, SEQ, ItemIndex, bSetup, s_date, set_date
from tblGuildHouse_Furniture (nolock)
where serverindex = ' + @serverindex + ' and m_idGuild = ' + @m_idGuild +''
)
end
else if @SEQ <> 0
begin
-- EXEC(' insert into LOG_' + @serverindex + '_DBF.dbo.tblGuildHouse_FurnitureLog
EXEC(' insert into LOGGING_01_DBF.dbo.tblGuildHouse_FurnitureLog (
serverindex, m_idGuild, SEQ, ItemIndex, bSetup, s_date, set_date
)
SELECT serverindex, m_idGuild, SEQ, ItemIndex, bSetup, s_date, set_date
from tblGuildHouse_Furniture (nolock)
where serverindex = ' + @serverindex + ' and m_idGuild = ' + @m_idGuild + ' and SEQ = ' + @SEQ + ' '
)
end
GO
/****** Object: StoredProcedure [dbo].[usp_GuildHouse_Log] Script Date: 04/03/2010 12:42:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
/*============================================================
1. ??? : ???
2. ??? : 2009.11.23
3. ???? ? : usp_GuildHouse_Log
4. ???? ?? : ?? ??? Log ??
5. ????
@serverindex char(2) ???
@m_idGuild char (6) ?????
@SEQ int SEQ
@dwItemId int ?? ITEM
@bSetup int ?? ??
6. ???
7. ?? ??
8. ?? ?? ??
EXEC usp_GuildHouse_Log '05', '123456'
9. ?? ? ident ? ???
select * from tblGuildHouse
delete tblGuildHouse
============================================================*/
CREATE proc [dbo].[usp_GuildHouse_Log]
@serverindex char(2),
@m_idGuild char (6),
@SEQ int = 0
as
set nocount on
set xact_abort on
-- EXEC(' insert into LOG_' + @serverindex + '_DBF.dbo.tblGuildHouse_FurnitureLog
EXEC(' insert into LOGGING_01_DBF.dbo.tblGuildHouseLog (
serverindex, m_idGuild, dwWorldID, tKeepTime, m_szGuild
)
SELECT serverindex, m_idGuild, dwWorldID, tKeepTime, m_szGuild
from tblGuildHouse (nolock)
where serverindex = ' + @serverindex + ' and m_idGuild = ' + @m_idGuild + ' '
)
GO