Retreiving data from SQL Server

2003-06-17 Thread Smith, Ron L.
Can anyone give me an example of an SQL statement that will retrieve data from SQL Server. What is the best way to do this? Thanks! Ron Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know

RE: Retreiving data from SQL Server

2003-06-17 Thread Farnsworth, Dave
You must put double quotes around column names in select and where clauses and it is VERY case sensitive. Note the following query; select concontainer from [EMAIL PROTECTED] where conID = 1; if you tried this with the field of conid it would fail. It's a pain in the butt that is how it

RE: Retreiving data from SQL Server

2003-06-17 Thread Goulet, Dick
Dave, You also need to put double quotes around table names as they conform to the same rules as columns. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, June 17, 2003 10:55 AM To: Multiple recipients of list ORACLE-L You must put