Jump to content

hbsilva

Member
  • Content Count

    3
  • Joined

  • Last visited

About hbsilva

  • Rank
    Newbie

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. BASTA RODAR ESSE QUERY NO SQL SERVER QUE AS CONTAS NORMAIS VAI FUNCIONAR USE [RF_USER] GO /****** Object: StoredProcedure [dbo].[pSelect_AccountPass] Script Date: 02/05/2013 10:33:02 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pSelect_AccountPass]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[pSelect_AccountPass] GO USE [RF_USER] GO /****** Object: StoredProcedure [dbo].[pSelect_AccountPass] Script Date: 02/05/2013 10:33:02 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO CREATE PROCEDURE [dbo].[pSelect_AccountPass] @id varchar(13) AS DECLARE @curdate DATETIME DECLARE @birthdate DATETIME DECLARE @plusdate DATETIME DECLARE @AgeResult TINYINT SET @curdate = GETDATE() SET @birthdate = (SELECT birthdate FROM tbl_rfaccount WHERE ID = CONVERT(BINARY, @id)) IF(ISDATE(@birthdate) = 1) BEGIN SET @plusdate = DATEADD(yy, 18, CONVERT(DATETIME, @birthdate)) END IF(ISDATE(@curdate) = 1) AND (@curdate >= @plusdate) BEGIN SET @AgeResult = 0 END ELSE BEGIN SET @AgeResult = 1 END SELECT RTRIM( CONVERT( VARCHAR(24), password) ), accounttype, AgeResult= @AgeResult FROM tbl_rfaccount WHERE ID = CONVERT(BINARY, @id) GO
  2. hbsilva

    How do I fix my skill miss?

    EXPLIQUE MELHOR SEU ERRO !
  3. hbsilva

    Client + Server in same PC Doesn't work

    LIBERE NO FIREWALL E PONHA SEU IP EM DMZ (NO ROTEADOR) . SE TIVER MAIS DUVIDAS ME CHAMA
×
×
  • Create New...