Summary: In the interest of the first one to post on the forum and because I'm having a tough time wrapping my head around this one, here goes: I have a table ...
Summary: Hi I am trying to spool the output of 3 sql queries into different sheets of the same excel file. Like Query 1 result in sheet 1 of report.xls Quer...
Summary: You would be much better off installing SQL Server express from microsoft's web site. It is nearly identical to SQL Server, it just has a limited num...
Summary: Use google (or some search engine) to find resources. I did a google on "sql oracle tutorial" and found numerous links to books, papers and websites....
Summary: Hi all, I'm new to all of this, so be patient. I'll explain as much as I can. I bought a program that is a front-end to a SQL Express database. Ever...
Summary: Hi all, Recently I try some script from microsoft which need to connect to SQL Server 2000 (SP4) database using ODBC, but my PC keep on show me dataso...
Summary: SQL is not a Database: SQL is a tool you can use to manipulate data in a database. Almost all DB products support some type of SQL, some support the...
Summary: I am trying to connect to a SQL database and it returns the following error when I want to connect SQL Server through the System DSN in Control Panel ...
Summary: I have two very different reports that I have to run to get all the info out of an inventory database. The first one extracts the current inventory, ...
Summary: We're using sql server 2005 and when running our etl tool the server acts strange. Uptill now we have had no problems what so ever. Today when running...
Summary: I find myself very confused regarding database tools and a matter of what does what and what is capable of what. For a personal endeavor of mine, i wi...
Summary: Receiving the error message, "The database could not be accessed. In order to access this database, check your network connection and verify that your...
Summary: Thanks, you convince me. As you suggested, I'll keep the 2 column style so I can still "SORT BY col_a/col_b" which sounds faster than "SORT BY ((col_c...
Summary: i am a non-professional user of MS Access for the last 8 years and through playing, eperimenting and searching i can say that have become pretty good ...
Summary: from MS Access. when i access a database file which is in a different machine (MS SQL Server), and after working on and saving this file in my local w...
Summary: I am updating two fields in a sql server DB from a VB6 application. field2 updates fine but field1 is not updating at all. I tried the query in anal...
Summary: Scenario: Two different location connect by a dedicated VPN line with 512K bit bandwidth. Both site running a MS SQL server on a SBS server. Both site...
Summary: Hi, I have a quick question regarding unions in SQL 2005 (using express edition for development at the moment). I am setting up somewhat of a stock ma...
Summary: Two good suggestions so far. Michael's right...As far as complexity goes, this barely registers on the meter in the database world. Bare easiest to j...
Summary: I would like to Synchronize an online database to offline database. we use a online shopping cart that runs on sql and we use a software to track sale...
Summary: A PRIMARY key has to be unique, meaning that there cannot be duplicates. It doesn't make sense that the Interests table would have a unique key, which...
Summary: Jennifer, C++ is not the only language that uses the bcp extension; it's also used in SQL to export/import data. http://www.google.com/search?q=SQL+.....
Summary: I am the IT manager at a community organisation with about 10000 members. All members data is currently in an Access database on our file server in th...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
