ALTER PROCEDURE [dbo].[P_Spcl_IsJoinGame]
(@UserId nvarchar(10),
@TableName nvarchar(20))
AS
SET NOCOUNT ON;
declare @ReturnCount int
declare @sqlstr nvarchar(256)
set @sqlstr='select @count=count(*) from ' + @TableName + ' with (nolock) where User_Id=' + @UserId
exec sp_executesql @sqlstr,N'@count int output',@ReturnCount output
IF @ReturnCount>0
RETURN 1
ELSE
RETURN 0