home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 18,725 of 19,505   
   Erland Sommarskog to Gene Wirchenko   
   Re: Escape Characters in Strings   
   23 Aug 12 10:22:54   
   
   From: esquel@sommarskog.se   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca