error?, how, do you need to copy and query or what?CREATE PROCEDURE [dbo].[cabal_sp_get_charpet]
(@PetSerial INT, @PetId INT, @CharId INT, @KINdIdx INT)
AS BEGIN SELECT * FROM cabal_pet_table where OwnerCharIdx = @CharId End
this is my Code Please Like This ^_^
CREATE PROCEDURE [dbo].[cabal_sp_mail_send_all]
(@Title varchar(40), @Content varchar(512), @Alz bigint = 0, @itemKindIdx int = 0, @itemOption int = 0, @itemDurationIdx int = 0)
AS BEGIN DECLARE @CharacterIdx int DECLARE CURSOR_ACCOUNTS CURSOR FOR SELECT CharacterIdx FROM Server01.dbo.cabal_character_table
OPEN CURSOR_ACCOUNTS FETCH NEXT FROM CURSOR_ACCOUNTS INTO @CharacterIdx WHILE @@FETCH_STATUS = 0 BEGIN INSERT INTO
cabal_mail_received_table
( IsCommitted, ReceiverCharIdx, Type, Alz, ItemKindIdx, ItemOption, ItemDurationIdx, SenderCharIdx, Title, Content )
VALUES
(
1,
@CharacterIdx,
dbo.Mail_GetGMType(),
@Alz,
@itemKindIdx,
@itemOption,
@itemDurationIdx,
1,
-- GM : 1,
@Title,
@Content )
FETCH NEXT FROM CURSOR_ACCOUNTS INTO @CharacterIdx End CLOSE CURSOR_ACCOUNTS DEALLOCATE CURSOR_ACCOUNTS END
This is the Fixed on Mail sent to all ^_^ i hope you Like This
Most visitors online was 11705 , on 26 Apr 2024