Problems with the SQL query function
I am designing a website, and I’m having a problem with the SQL query function. My table looks like this:Table StructureRef_ID Mem_ID1001 10021001 10031001 10041002 10051003 10061003 10071003 1008When I try the command “select * from table where...
View Answer
| Aug 21 2008 4:16 PM GMT
| asked by
SQL Server Ask the Experts
SQL, Query, tables
Problem inserting data using OPENROWSET in SQL Server 2000
When I insert data into a table using OPENROWSET in SQL Server 2000, the data in the table comes up as “2.00804e+007” and “6.02303e+007”. Why might this be?
View Answer
| Jul 9 2008 5:56 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2000, tables, Functions
Designing Table Layout
Hi, I am doing very simply frequencies and descriptives but wondered if I can design the layout of the output table myself rather than exporting to Excel and copy pasting a million times...can anyone help?
Answer Question
| Jul 8 2008 8:57 AM GMT
| asked by
CMS
tables, Microsoft Excel, Database design
Error when trying to drop a table that doesn’t exist in RUNSQLSTM
If I try and DROP a table that does not exist the RUNSQLSTM will fail. Is it possible to monitor for this in the RUNSQLSTM so it won't fail?
View Answer
| Jul 2 2008 10:03 AM GMT
| asked by
Gingertosser
DROP, tables, RUNSQLSTM
