Introduction - If you have any usage issues, please Google them yourself
USE [CxGameTreasuredb]
GO
IF EXISTS (SELECT* FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID(N [dbo].[stock_data] ) and OBJECTPROPERTY(ID, N IsProcedure ) = 1)
DROP PROCEDURE [dbo].[stock_data]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[stock_data]
@cardcode [bigint],
@cardpass [nvarchar](50),
@userid [int]
WITH ENCRYPTION AS
BEGIN
DECLARE @Price [int]
DECLARE @IsCrad[bit]
IF EXISTS (SELECT UserID FROM QPTreasureDB.dbo.GameScoreLocker WHERE UserID=@UserID)
BEGIN
SELECT [ErrorDescribe]= 错误信息:您目前在银子游戏房间,不能进行银行操作!
RETURN
END