Summary: Personally I prefer ADO. I find it easier to use, and it's the successor to DAO. That said, if you want to run your SQL, you need to do something like...
Summary: Hi, I'm designin sort of asset manager software and i'm already stuck with some SQL-querys... :) Tables don't have all the fields yet, because it's ju...
Summary: I need SQl query to find out the last modfied date of columns in table. there are no date/time related columns in the table. But I what to find when ...
Summary: Hi all, I need a help in MS SQL Express query. I have a table named "tblTotalCust" and the fields are: [Date] date, [ServedTime] date, [TotalCustomer]...
Summary: Not being familiar with your SQL environment or your data, my guess is you need to do an outer join: FROM "AB_JOB", "CUSTOMER_ORDER", "OUTER SHEET_S...
Summary: Hello, I am Software Development Intern at a small company. We run Microsoft SQL Server 2000 on Win2k. One of our database tables was recently destroy...
Summary: oh yeah i did the where clause for file xxxx just tryna get one row working first. i'll try this once i have database access again thanks mdow. one th...
Summary: OK i first want to apoligze for posting a message a couple of months ago about the same issue. It's just that i have no idea what i am doing but i wan...
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, I have an issue i need to display a date say (14-sep-2005 11:20:00) as 14-sep-2005 12:20:00) and (22-dec-2005 11:20:00) as (22-dec-2005 11:20...
Summary: yeah Jennifer, i followed the instruction on the link you provided above, and changed the TCP/IP's regitery key's value to zero (0) like below: Named ...
Summary: To do this with SQL would likely require that the flavor of SQL you are using (MySql, Oracle, Informix, DB2, etc) contain a function that will convert...
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: I am trying to update a field in a sql server table. There are times when I may get multiple records returned in which case they will all need to be ...
Summary: Hello, Looking for some advice on choosing a local data source for a call reporting project that will have approximately 25 end users using it. I have...
Summary: hi, I need help on making a SQL query to find the total processing time of a document by each user by each day. The database is SQL server 2000. The...
Summary: "i want to show the unique record of every separate field" I'm not clear what you mean by this. Do you mean that for each field, you want to show al...
Summary: Yes, you need to look up CAST and CONVERT in the SQL Server Books Online - it will probably have an example that you want. ASUS M2NPV-VM <> Athlon ...
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: I have a sql database that I need to monitor with nagios but it will not work with sql 2005. I was wondering if a sql query that can watch the databas...
Summary: without the schema for these tables, it's hard to give you a fixed script, but I've run a few examples here and it looks like you have one of the two ...
Summary: Pl/SQL program in Ora 10g. I need to obtain a list of all the files in the Unix directory /data. Then I will take that list and use it in a DBIMPORT ...
Summary: Hi I am using VS 2008's VB.net and want to connect to SQL server 2008....I am new to SQL server so please help. What are the things I need to install ...
![[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
