| Groups | Blog | Home |
|
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 String data - right truncation error with numeric fields!!! Posted by armstrongjc NO[at]SPAM hotmail.com at 9/28/2004 9:19:53 PM Hello all,
I have a stored procedure I wrote:
CREATE PROCEDURE spCreditCheck
@MatchID integer, @Price numeric, @RepSC numeric, @Rep2SC numeric,
@DeskSC numeric, @CheckResult numeric OUTPUT
AS
Declare @CheckPrice numeric, @CheckRepSC numeric, @CheckRep2SC
numeric, @CheckDeskSC numeric, @Ch...more >>
Access SQL to Transact SQL - Translator? Posted by bill morgan at 9/28/2004 5:36:04 PM Friends,
I am new to SQL Server, and I access it mainly through
Access (ODBC DSN).
I need my queries to run faster, so I want to switch from
regular Access queries against linked SQL tables to faster
pass-through queries written in Transact SQL.
QUESTION: Does anyone know of an easy ...more >>
Getting data from FoxPro Posted by Andreas at 9/28/2004 12:24:20 PM I'm looking to build an application that will get data
from an HR system (built in Visual FoxPro 7.0), import it
into SQL Server, and process it there. I'm trying to
figure out what the best approach to doing this would be.
I would like to avoid any development in the FoxPro db -
no views...more >>
Where did SQLSRV32.DLL 2000.81.9042.00 come from? Posted by Fred Morrison at 9/28/2004 8:44:50 AM I have version 2000.81.9042.00 of SQLSRV32.DLL installed.
Does anyone know where this particular version came from?
Hotfix? The MDAC component checker tool gives no useful
information. I know that MDAC 2.8 will install version
2000.85.1022.00, but I'd first like to determine where
versio...more >>
Call-Level Interface (CLI) Posted by ezelasky NO[at]SPAM hotmail.com at 9/27/2004 12:03:13 PM I have just read about the Call-level interface, a library of DBMS
functions that can be called by an application program. Where can I
read more about the CLI function, Google & MSDN searches didn't yield
much and no examples etc. Does any one actually program to this to
facilitate data transf...more >>
Advantages OLEDB vs ODBC Posted by Hans Moser at 9/24/2004 11:56:12 AM Hi!
Could you give me a list of advantages using OLEDB in stead of ODBC? Is
there an idea of getting good informations how to handle OLEDB?
My problem is by using ODBC for a WebApplication the
system often is blocked. I hope the system gets
faster by using OLEDB. Is it like this?
Thanks,
...more >>
#DELETED displayed in all cells Posted by Jon Paskett at 9/23/2004 12:47:09 PM I have a SQL 2000 database and I'm using Access 2003 to gain access to the
tables. All cells contain #Deleted.
What am I doing wrong?
TIA
Jon
...more >>
OpenQuery to a LinkedServer Posted by Bob Kaine at 9/23/2004 8:21:45 AM I have SQL Server 2000 with Pervasive SQL 2000i attached
as a linked server. When I run the following...
UPDATE OPENQUERY(LINKEDSERVER, 'SELECT "START_ORDER_NO"
FROM "OECTLFIL" WHERE "FILE_KEY" = 1')
SET START_ORDER_NO = 0
----The START_ORDER_NO field contains a 48
Changing the SET cla...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQLServer/ODBC and nested subselects? Posted by JohnD at 9/23/2004 1:34:48 AM Hi,
I have a need, unfortunately, to use a subselect as part of an IN clause
in a WHERE statement. The subselect contains a parameter that must be
bound with SQLBindParameter.
However, when I run the code that binds the parameter I get an ODBC error:
"Synatx error or access violation."...more >>
string format in SQL Posted by clark at 9/22/2004 8:20:59 PM I was using the following command to update the data
source (a tab-delimited text file):
INSERT INTO table (COL1,COL2) VALUES ('AA','BB')
I found the updated text file looked like this:
"AA" "BB"
Could anyone tell me how to remove those double quotation
marks in the SQL command or conf...more >>
newbie Q Posted by Brent D. at 9/22/2004 12:49:28 PM Hi, and Thanks for your thoughts!
I am evaluating a product, and the sales team presents an
option I am not familiar with.
Can a SQL/OBDC connection accross the internet be
encrypted (via or utilizing) OBDC?
Any heads-up or caveats will be appreciated.
Brent...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |