freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Data porting homegrown tools andtechniques(wasRE:freebcp: add support for escaping characters?)

From: "Roger L. Reid" <roger.reid AT dpw.com>
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Data porting homegrown tools andtechniques(wasRE:freebcp: add support for escaping characters?)
Date: Mon, 3 Apr 2006 12:29:45 -0400

Right, in Sybase BAZ and baz are distinct. In SQL Server they need to
be disamiguated
(t.baz = o.BAZ)- a little more self documenting anyway.

> > select foo, bar, baz from ThisTable t, OtherTable o
> > where t.bar = o.bar and baz = BAZ;
>
> whats the issue with that ?
> is that a case sensitivity thing, where baz and BAZ are both column
> names ?

Re: [freetds] Data porting homegrown tools andtechniques(wasRE:freebcp: add support for escaping characters?), Roger L. Reid, 04/03/2006