Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail From: Erland Sommarskog Newsgroups: comp.databases.ms-sqlserver Subject: Re: Escape Characters in Strings Date: Thu, 23 Aug 2012 10:22:54 +0000 (UTC) Organization: Erland Sommarskog Lines: 29 Message-ID: References: <2s0a38toaa3n1th1e42kmat8n0ei6v9bah@4ax.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Injection-Date: Thu, 23 Aug 2012 10:22:54 +0000 (UTC) Injection-Info: mx04.eternal-september.org; posting-host="1bbf89cf6d97a98086f02eab6f51f760"; logging-data="14232"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19uV/Y3Eplucsv0WIeqxeuR" User-Agent: Xnews/2005.10.03 Mime-proxy/1.4.c.4 (Win32) Cancel-Lock: sha1:FaTpkPBMHTTHZXvrWrGS6OGEJF8= Xref: csiph.com comp.databases.ms-sqlserver:1231 Gene Wirchenko (genew@ocis.net) writes: > Rats! I would be using VBScript. I hope the syntax is similar. Yes. You can to the same thing in old ADO. The syntax and the names are somewhat different though. Then again, I know we have discussed before, but VBscript and old ADO in 2012 for new development is just crazy. > There appear to be pieces missing. Presumably, the other > parameters get similar treatment in their declared order, and > something must state to go. Yes, I only included the first parameter for brevity. You don't have to create them in the order they are declared in the procedure since you provide the parameter names. And, yes, you need code to execute the command, but that is the same thing as when you use command type text; there is no difference in that regard. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx