| Groups | Blog | Home |
|
March 2003 May 2003 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 November 2007 |
Filter by week: 1 2 3 4 5 dbnmpipe.exe for MS-DOS Posted by Cash Woodward at 6/21/2004 11:58:33 AM I recently purchased sql 2000.
I need connectivity for an old DOS program.
I see that I need the file DBNMPIPE.EXE
I can't find this file anywhere on my CD's or on
Microsofts website.
Where can I get it?...more >>
MS Access and SQL Server Posted by Tony Myhrberg at 6/21/2004 7:06:17 AM If you use MS Access to update data in SQL Server i guess
you can choose between two methods to connect to a SQL
Server databasem, create an access database with a linked
table via ODBC or create an access projekt via OLE DB.
Both methods gives me problem:
Linked Table: When my tables get ...more >>
Master DB restore on another SQL server Posted by enam77 NO[at]SPAM hotmail.com at 6/20/2004 10:46:33 PM Hi,
How I can restore MASTER database on another SQL server?
If I want to resote got msg "restore can be done only from
single user mode" - what should I do......more >>
populate full text Posted by Farhan Iqbal at 6/18/2004 4:53:52 PM Hi all,
I want to populate full text index via query is there any way? please
elaborate
Thanx
Farhan Iqbal
...more >>
Help with Insert/Trigger Posted by Pete at 6/18/2004 10:55:01 AM Just curious if there's anything in SQL comparable to a FOR EACH ROW trigger in Oracle.
I'm doing an import of a bunch of rows into a parent table using an INSERT/SELECT statement and I have triggers that fire pulling data from the same row in the source table into the child tables and creating t...more >>
CSV Field Stored Procedure Posted by Steve at 6/18/2004 8:28:59 AM Hi All,
I would like to submit a large amount of CSV text into a =
stored procedure. At present I'm using a varchar(8000) parameter and =
then converting this into a temporary table using something like the sql =
below. My question is does anybody have any suggestions on how to g...more >>
indexing Posted by skc at 6/18/2004 12:33:14 AM I am running SQL 2000 and Crystal Reports ASP.
I have two tables called customer and invoice. There are
100000 customers and 7200000 invoices.
Here are the fields:
customer
- id ...1 to 100000
- custno ...1 to 100000
- name
- address1
- address2
- postcode
...more >>
Complex Query - Part II Posted by Preet Kanwaljit Singh Shergill at 6/16/2004 11:03:50 PM
I am passing the following query:
select type, count(*) as 'Total', sum(case when status = 'Closed' then 1
else 0 end) as 'Closed',
sum(case when status = 'Pending' then 1 else 0 end) as 'Pending',
sum(case when status = 'Escalated' then 1 else 0 end) as 'Escalated'
from ticket where l...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Interfacing with SQL Posted by Illicom Newsgroups at 6/15/2004 7:11:09 PM What is the best and quickest way to develop, or download, an interface that
clients can use to query sql?
Thanks,
CJ
...more >>
Passing parameters to a stored proc. from access Posted by Scamps at 6/15/2004 11:09:58 AM I have recently moved from developing an Access DB to
developing an Access.adp using SQL Server2000.
I havent been able to figure out how to pass a parameter
from a control in an Access form to a Stored procedure.
It was easy in Access but I just dont get it in
Access/SQL stored procedure....more >>
Design View Posted by Don Stull at 6/15/2004 9:19:22 AM I have a database created by another developer that I purchased and was
recently instructed to change some values in some tables form one kind to
another like "NOT NULL" to "NULL" or change something to a "FLOAT" I am not
that good at SQL but have always done this stuff with the Query Anylizer.....more >>
cant connect to SQL2K running on W2K3SVR but can connect to SQL2K running W2KSVR with same connection string Posted by Dave at 6/15/2004 12:22:42 AM Hi,
I can't connect using an OLE DB connection string to SQL2K Server (SP3)
running on a Windows2003 Server, but using the same connection string (with
the address changed of course), I can connect to SQL2K Server (SP3) running
on Windows2000 Server.
I figure it must be a security issue on ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |