|
|
|
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 Date Difference Posted by muffin1975_1 NO[at]SPAM eskom.co.za at 1/21/2005 3:01:53 PM Hi
I'm new to this whole SQL thing(electrical technician, heavy current). I use
TOAD to write queries on our db.
Question is : How do I subtract 2 dates from each other & format the result
to HH:mm:ss in new collumn. I usually do this in MsExcell after extracting
the data.
Thanks in advance....more >>
[ODBC SQL Server Driver]Communication Link Failure Posted by topason at 1/21/2005 7:15:03 AM I have a third party Client (Rational Clearquest) connecting to a SQL server
with an ODBC connection. Recently a few of the developers (not all) have
started getting "[ODBC SQL Server Driver]Communication Link Failure" after 5
minutes of inactivity.
I had the a network sniff done on the ...more >>
ODBC Connection Failure Posted by syed rahman via SQLMonster.com at 1/20/2005 9:48:16 PM Hi,
I'm trying to create a ODBC connection to SQL server 2000 using SQL server authentication. I have login id "lucky9797" and password "tool" but I'm keep getting the following error message:
Connection Failed:
SQLState:'28000'
SQL Server Error: 18456
[Microsoft][OD...more >>
reading a text file as it is written Posted by Greg Stigers, MCSA at 1/20/2005 6:50:41 PM A remote office developed a PC-based app that writes its data to a text
file. We want to maintain this data at the main office, and in SQL Server,
due to the significance of the data. A typical day's file may have a couple
hundred records, written over an eight hour shift. Rather than changing...more >>
MDAC Posted by ¶Ë¤ß¤H at 1/20/2005 3:32:05 PM how to unistall MDAC 2.8?
...more >>
Trouble with Primary key ater insert trigger Posted by Günther Rühmann at 1/20/2005 10:38:36 AM
Hello,
i habe some trouble with a sql 2000 appclication
The envisonment:
SQL-2000 - Server MS Access2000 - Client that uses SQL server tables via
ODBC.
After inserting a row to a table table_1 an insert trigger is running that
inserts some fields of this row to a second table tabel_2.
T...more >>
possible to call a table valued User Defined Function thru ODBC Posted by fpdave at 1/20/2005 6:19:29 AM I want to be able to call a SQL Server User Defined Function that is a
table valued UDF. I have existing code that uses ODBC and calling UDFs
is going to be a lot easier than calling stored procedures, as the
syntax is close to using a table itself (at least in T-SQL it is).
But, I suspect th...more >>
need a consultant to quickly go over some code Posted by Neil W. at 1/19/2005 7:49:29 AM I need to engage an odbc consultant for a few hours to quickly go over some
code of mine. You must be experienced in coding ODBC in C. The program uses
straight C (not C++ and not MFC). I need this help immediately.
Please email right away if you can do it. Please include your rates.
Thank...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Distributed query does not work between 64bit and 32bit servers Posted by roustam NO[at]SPAM hotbox.ru at 1/19/2005 12:48:28 AM Hi!
I have two MS SQL servers: Server1 & Server2. Both are Win2003 Server
+ MS SQL 2000, but the first is 64bit version, while second is a 32bit
version.
When I try to do this:
insert into Server2.mydb.dbo.table1 select * from
Server1.mydb.dbo.table1 order by add_item
I get an error:
S...more >>
differences between ORACLE and MS SQL Posted by evagelos at 1/18/2005 1:26:45 AM i want to create some queerys in MS-SQL
1)
this queery in ORACLE-SQL works fine , in MS-SQL?
SELECT code_card, card_date + 31
FROM card
i searce and find out that i must use "DATEADD ( datepart , number, date )"
but how?
2)
this queery in ORACLE-SQL works fine , in MS-SQL?
...more >>
Q186726 Error 80004005 Occurs When Retrieving Data from SQL Server Posted by shalafi at 1/17/2005 8:15:02 PM Does anyone know if this article is valid for connection between servers.
I'm getting an intermittent
|308|80004005|[Microsoft][ODBC_SQL_Server_Driver]Timeout_expired when a
website running on a windows 2000sp3 tries to write data to sql 2000 server
running on windows 2003 server. Could th...more >>
simple odbc sample using C? Posted by Neil W at 1/17/2005 5:56:09 PM I am new to odbc - can anyone point me to a simple odbc example written in C
(not using MFC) that does a simple select and a simple insert? Thanks.
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |