Code:
USE [BreezeNet]
GO
/****** Object: StoredProcedure [dbo].[BN_WarZ_CheckSerial] Script Date: 02/21/2014 14:56:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ----------------------------
-- Procedure structure for [BN_WarZ_CheckSerial]
-- ----------------------------
ALTER PROCEDURE [dbo].[BN_WarZ_CheckSerial]
@in_SerialKey varchar(128)
AS
BEGIN
SET NOCOUNT ON;
-- temp function used for checking if serial exists
select * from WarZSerials where SerialKey=@in_SerialKey
return
END