32 lines
689 B
Transact-SQL
32 lines
689 B
Transact-SQL
USE [LosaGame]
|
|
GO
|
|
|
|
/****** Object: StoredProcedure [dbo].[game_quest_delete] Script Date: 11/21/2018 11:09:44 ******/
|
|
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[game_quest_delete]') AND type in (N'P', N'PC'))
|
|
DROP PROCEDURE [dbo].[game_quest_delete]
|
|
GO
|
|
|
|
USE [LosaGame]
|
|
GO
|
|
|
|
/****** Object: StoredProcedure [dbo].[game_quest_delete] Script Date: 11/21/2018 11:09:44 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
CREATE PROCEDURE [dbo].[game_quest_delete]
|
|
(
|
|
@accountIDX int
|
|
)
|
|
AS
|
|
|
|
DELETE FROM userQuestDB WHERE accountIDX = @accountIDX
|
|
DELETE FROM userQuestCompleteDB WHERE accountIDX = @accountIDX
|
|
|
|
|
|
GO
|
|
|
|
|