Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1236

Re: Escape Characters in Strings

Show all headers | View raw

Erland Sommarskog wrote:
> Bob Barrows (reb01501@NOSPAMyahoo.com) writes:
>> Under the covers, a command object is created (similarly as to when
>> the connection's Execute method is called) and parameter objects are
>> appended, typed based on that "best guess", which uses the types (or
>> subtypes given vbscript's restriction to Variant datatypes) of the
>> passed values in making that guess. Yes, theoretically, the best
>> guess could be wrong, but in my experience it never has been - at
>> worst, an implicit conversion might be required. Of course, my
>> environment has always been very simple. And as long as you properly
>> type your VB objects, the chance of a bad guess that requires more
>> than a conversion from varchar to nvarchar, or float to integer is
>> slim.
>
> The area that would make me the most worried are dates, particularly
> if you have them in string fields. If they are passed as (n)varchar,
> conversion happens in SQL Server which can give a headache.

Right. They need to be passed as dates, either as the result of using 
CDate() or Dateserial() or literal dates (delimited with hash marks in 
vb/vbscript). 

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

Escape Characters in Strings Gene Wirchenko <genew@ocis.net> - 2012-08-21 15:39 -0700
  Re: Escape Characters in Strings Erland Sommarskog <esquel@sommarskog.se> - 2012-08-22 07:33 +0000
    Re: Escape Characters in Strings Gene Wirchenko <genew@ocis.net> - 2012-08-22 09:10 -0700
      Re: Escape Characters in Strings Erland Sommarskog <esquel@sommarskog.se> - 2012-08-22 21:14 +0200
        Re: Escape Characters in Strings Gene Wirchenko <genew@ocis.net> - 2012-08-22 13:53 -0700
          Re: Escape Characters in Strings Erland Sommarskog <esquel@sommarskog.se> - 2012-08-22 23:35 +0200
            Re: Escape Characters in Strings Gene Wirchenko <genew@ocis.net> - 2012-08-22 17:38 -0700
              Re: Escape Characters in Strings Erland Sommarskog <esquel@sommarskog.se> - 2012-08-23 10:22 +0000
          Re: Escape Characters in Strings "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2012-08-23 07:05 -0400
            Re: Escape Characters in Strings Erland Sommarskog <esquel@sommarskog.se> - 2012-08-23 23:13 +0200
              Re: Escape Characters in Strings "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2012-08-23 18:22 -0400
                Re: Escape Characters in Strings Erland Sommarskog <esquel@sommarskog.se> - 2012-08-24 07:40 +0000
                Re: Escape Characters in Strings "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2012-08-24 06:16 -0400

csiph-web