Posted by Luuk on 08/22/07 07:13

>>
>> SELECT * from table where name<>"" and employeeId<>0 and email<>"";
>
> Just a note:
>
> Please, no double quotes for string constants, use single quotes.
>
> Double quotes are reserved for "delimited identifiers" as defined by the
> SQL Standard and supported by MS SQL Server.
>

I tend to forget those things, as its different in every programming
evironment i use....
some of the don't care, some use double quotes, and some use single
quotes...

thanks anyway for this reminder....

• Next in forum: Re: Problem with DB_OWNER role..
• Prev in forum: Re: Need to find instances of duplicates within a column; joining 2 tables.
• Thread view: Re: MS SQL dealing with duplicate columns in rows?

[Reply to this message]