Recent IT Questions

1 - 4 of 4
<<PREVIOUS 1 NEXT>>

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


1 - 4 of 4
<<PREVIOUS 1 NEXT>>