|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 |
Filter by week: 1 2 3 4 5 Counting occurences Posted by M McEvoy at 5/21/2004 9:40:51 PM Hi,
Can anyone tell me how I would produce a table that holds just e.g. the
countries that occur more than once in another table?
This is what I have:
SELECT
city.country, count(*) as count
FROM city
GROUP BY city.country having count > 1;
But this gives me a table with 2 columns whi...more >>
invalid name Posted by india at 5/21/2004 5:41:03 PM When I try to save tables. It gives me an ODBC[Microssoft server] invalid name 'id'. Can you please help with this...more >>
Connecting to Microsoft SQL Server Posted by Chris at 5/21/2004 4:31:02 PM Hi. Im just starting to learn Microsoft Visual Basic .Net, I'm having problem connecting to Microsoft Sql Server for the sample database Northwind. I can see SQL Server Service Manager on my taskbar but not connected. Please help thanks....more >>
ODBC vs OLE DB ??? Posted by Grant Reid at 5/19/2004 8:20:14 PM Here is an except from the book "SQL Server 2000 Weekend Crash Course"
OSQL-A command-line utility used to connect to SQL Server and execute
Transact-SQL statements (covered in Session 8). The results of the executed
commands will be displayed in the DOS console window. OSQL uses the ODBC
(Open ...more >>
Linking SQL and Access 2000 tables Posted by sean at 5/19/2004 7:58:21 AM Hey-
I am new to SQL and have been working on a database in it
that involves a column with html addresses. I have tried
linking an access database to the SQL server DB and it
will link but will not allow me to edit HTML sites into
the SQL database. I was wondering if there is any way I
...more >>
Is it easy to store phots and PDFs in SQL Server? Posted by wawork NO[at]SPAM hotmail.com at 5/18/2004 10:15:44 PM Is it easy to store and retrive photos and PDFs in SQL Server? Is any
programming involved or is it transparent to the user?
Thank You,
Randy K
wawork@hotmail.com...more >>
MSDE Posted by Joanne at 5/17/2004 9:40:09 PM I would appreciate any help, I'm trying to connect a web front-end to an
Access 2000 database using MSDE, and I have it working using Jet but would
like to connect the database using MSDE.
I would appreciate any advice to where I need to edit the code, the code is
as follows: (which is se...more >>
sql odbc links Posted by micke at 5/17/2004 7:44:15 PM This one has been driving me up a wall for about two weeks.
I am new to the SQL enviornment.
My boss comes from a programming background and loves to
create odbc links to our sql db to generate reports and
anaylize data.
We created a MS Access 2000 db with odbc links to SQL on a
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
[Microsoft][ODBC SQL Server Driver] Timeout Expired Posted by DJ at 5/17/2004 1:08:58 PM Hello,
I installed MS SQL Server 2000 Evaluation Edition on
Windows XP Pro PC. I have database on the same PC. When I
am running a query(view) from Query Analyser I
get "[Microsoft][ODBC SQL Server Driver] Timeout Expired"
error message . When I am running the same view on
smaller amount ...more >>
troubleshuting with conect SQL server with Delphi Posted by mystek20 NO[at]SPAM poczta.onet.pl at 5/16/2004 2:09:15 AM In delphi ist DBE Administrator where I have to set few
parametrs. On SQL Server I'm login on windows
autorisacion on administrator. What a parametr I have to
set in delphi 5? ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |