Re: SQL to search for column name
I beleive you could start by looking at a lot of OTC's answers......
Quote: "Even though I so ashamedly answered the question properly. I like this answere much better. I was just to lazy to dream up a smart ass answer. Is there a FM where I could look those up? B-) " I beleive you could start by looking at a lot of OTC's answers......
theusaro... said > I beleive you could start by looking at a lot of OTC's answers...... Yes this is a very good place to start. Don't look at my posts because I am easy and will basically give it up for anyone. I should probably seek help.
select favourite_cluebat
from where_you_left_it
where ever_user_is
and smack_user_upside_the_head
result
1 row
"user_gets_off_fat_arse_and_reads_manuals"
theusarools@hotmail.co.uk said: > > I beleive you could start by looking at a lot of OTC's answers...... The ones that say "RTFM", perhaps? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche did i mention i like nulls? heck, i even go so far as to say that all columns in a table except the primary key could/should be nullable. this has certain advantages, for example, if you need to insert a child record and you don't have a parent row for it, just do an insert into the parent table with the primary key value (everything else null), and voila, relational integrity is preserved. but this is, admittedly, a bit controversial among modellers. --r937, dbforums.com