Do you mean delete all the data or Export the data?
Clint
- Original Message -
From: Jason Larson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, March 08, 2002 10:22 AM
Subject: OT: SQL Statement dumping data
I was wondering if anybody had the sql statement that will
err...
DELETE FROM tablename
Is that what you mean?
- Original Message -
From: Jason Larson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, March 08, 2002 4:22 PM
Subject: OT: SQL Statement dumping data
I was wondering if anybody had the sql statement that will allow
-
From: Clint Tredway [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 9:26 AM
To: CF-Talk
Subject: Re: SQL Statement dumping data
Do you mean delete all the data or Export the data?
Clint
- Original Message -
From: Jason Larson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent
you an do a DTS to a text file, if that's what you're after.
alternately, check www.swynk.com. they have a FANTASTIC script library
for SQL server.
christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com
-Original
If dump means delete delete from tablename
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector - Commerce Builder
- Original Message -
From: Jason Larson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, March 08, 2002 10:22 AM
Subject: OT: SQL
if you mean delete all the data, use the Purge command. It is very
fast.
Kathryn Butterly
Web Developer
Washington Mutual Finance
813 632-4490
[EMAIL PROTECTED]
-Original Message-
From: Jason Larson [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 11:23 AM
To: CF-Talk
Subject:
[mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 11:31 AM
To: CF-Talk
Subject: RE: SQL Statement dumping data
What I am trying to accomplish is:
I have a client that will be pushing up a csv file to a site and then I
will setup a autmoated task that will dump all the data in a table
TRUNCATE TABLE MyTable
Chris
--
Original Message
From: Jason Larson[EMAIL PROTECTED]
Subject: RE: SQL Statement dumping data
Date: Fri, 8 Mar 2002 09:30:54 -0700
What I am trying to accomplish is:
I have a client that will be pushing up a csv file
-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 9:50 AM
To: CF-Talk
Subject: RE: SQL Statement dumping data
set up a DTS package to import the CSV file.
create an SP to run the DTS package.
use SQL Agent to schedule the SP.
christopher olive
cto
site, then you are placing
unnecessary load on your servers.
My thoughts, not yours
Shawn Grover
-Original Message-
From: Jason Larson [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 10:01 AM
To: CF-Talk
Subject: RE: SQL Statement dumping data
WOW!!, I haven't worked with DTS
manually for even further control.
Mark
-Original Message-
From: Jason Larson [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 9:01 AM
To: CF-Talk
Subject: RE: SQL Statement dumping data
WOW!!, I haven't worked with DTS packages and not much with stored
procedures. I will do some
PS - Chris, do you have an example of an SP that executes a DTS package? I
would find that useful if you do.
Mark
-Original Message-
From: Jason Larson [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 9:01 AM
To: CF-Talk
Subject: RE: SQL Statement dumping data
WOW!!, I haven't
WOW!!, I haven't worked with DTS packages and not much with stored
procedures. I will do some research. You think that this is a better
solution then building a cf template and setup an automated task to run
the cf template (in order to process the csv file)?
Yes that will be much better.
-
From: Jason Larson [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 12:01 PM
To: CF-Talk
Subject: RE: SQL Statement dumping data
WOW!!, I haven't worked with DTS packages and not much with stored
procedures. I will do some research. You think that this is a better
solution then building
.
410.931.4092
http://www.atnetsolutions.com
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 2:24 PM
To: CF-Talk
Subject: RE: SQL Statement dumping data
PS - Chris, do you have an example of an SP that executes a DTS package? I
would find
15 matches
Mail list logo