SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO /* Descripción: Procedimiento que muestra la lista de procesos de cargas configurados en el sistema. Este procedimiento se conecta además a la base de soex para obtener la lista de las campañas. --------------------------------------------------------------------- Autor: Motivo: Fecha: Control de cambio: ATM Crea 11-05-2009 Se crea el procedimiento almacenado */ ALTER PROCEDURE [dbo].[SEL_PROCESOS] @CODIGO INT = NULL, @CONTRATO INT = NULL, @CAMPANA INT = NULL AS
ASP.NET’s default mode is not to allow you access to the web service test forms from remote machines. Loading your ASMX page from a remote machine will produce the following text under the Test section: “The test form is only available for requests from the local machine“. I was able to get around this by placing the following in the Web.Config under the System.Web section:
<webServices>
<protocols>
<add name="HttpPost" />
<add name="HttpGet" />
</protocols>
</webServices>
Fuente: http://weblogs.asp.net/markbrown/archive/2004/05/18/134212.aspx
The DateTime type can be formatted with a string pattern in the VB.NET language. Conceptually, this is simple, but in practice there are some details you must account for if you want a functional program. As shown in this article, formatting your DateTime as a string is straightforward with an understanding of the syntax.