addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1linklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

Re: [lampsoftware-8] Microsoft SQL syntax question

From: Robert G.
Sent on: Friday, January 11, 2008 10:39 AM
I believe the syntax in MS SQL is [database].[table] so it would be something like

SELECT * from [my_table] where [column_name] LIKE '%foobar%';

Not sure about the quotes around the like. It has been years since I have touched anything MS SQL. Sorry.


On Jan 11,[masked]:31 AM, Chris Verges <[address removed]> wrote:
Hey all,

I apologize for tainting this LAMP list with a Microsoft SQL question, but
it's driving me nuts and I need some help.  Under MySQL, I'm able to form
queries like:

   SELECT * from `my_table` where `column_name` LIKE '%foobar%';

The tables and columns are delineated by a tick (`).

This doesn't seem to work in Microsoft SQL, however.  Does anyone know what
the corresponding delineated syntax is?  And more importantly, is there a
common syntax which will work for both?  (Leaving out the delineator mark is
not an option, as we have some table/column names which can conflict with
built-in keywords for the DBMS.)

Thanks for the help!

Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed] )
This message was sent by Chris Verges ([address removed]) from The Silicon Valley LAMP Meetup Group.
To learn more about Chris Verges, visit his/her member profile:
To unsubscribe or to update your mailing list settings, click here: Customer Service: [address removed]
632 Broadway New York NY 10012 USA

Robert A. Gonzalez

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy