<jhofmeyr@googlemail.com> wrote in message
news:1193880325.817398.265970@k79g2000hse.googlegroups.com...
> On Nov 1, 12:41 am, "Andy" <kc2...@yahoo.com> wrote:
>> Hi,
>> I have some table in old DB with column named "index".
>> How to write insert statement to not get an error?
>> if I try to do that SQl Server is saying "error near index...etc"
>> insert into table (index, name) values (1,'Bob')
>> got to be some workaround?
>> thanks
>
> Hi Andy,
>
> The problem is because the word "index" (and in-fact the word "name"
> as well, but SQL is more forgiving with this one) is a reserved word
> in SQL Server.
> Try:
> INSERT INTO table ([index], [name])
> VALUES (1, 'Bob')
>
> --CELKO-- might tell you that Standard SQL convention is to use double
> quotes instead of square brackets, but I prefer the brackets myself :)
>
> Good Luck!
> J
>

On Nov 1, 12:41 am, "Andy" <kc2...@yahoo.com> wrote:
> Hi,
> I have some table in old DB with column named "index".
> How to write insert statement to not get an error?
> if I try to do that SQl Server is saying "error near index...etc"
> insert into table (index, name) values (1,'Bob')
> got to be some workaround?
> thanks