Posted by ice on 12/28/06 12:59

Hugo Kornelis wrote:
> On 27 Dec 2006 11:01:28 -0800, ice wrote:
>
> (snip)
> >I was not able to make it work, getting an a error about a relation.*
> >
> >
> >CREATE TABLE contacted (
> (snip)
> >COPY clients (lname, fname, company, address1, address2, city, state,
> >zip, active, id) FROM stdin;
> >Smith Joe Small Co Smallville Rd Bigton NY 12234 t 1
> (snip)
>
> Hi ice,
>
> Thanks for posting the table structures. The first thing I noticed is
> that some of the datatypes used are not valid on MS SQL Server. You are
> apparently using some other DBMS. You might get better help when posting
> in a newsgroup for your DBMS!
>
> That being said, I am willing to look into your problem - but only if
> you can post the data as INSERT statements (the COPY statement you used
> is not supported on MS SQL Server either), *and* if you post the exact
> and complete error message you got (use copy and paste if possible).
>
> --
> Hugo Kornelis, SQL Server MVP
OK.
Thanks.

[Back to original message]