Background:
I am converting a huge DBase db into SQL. What I have done is extracted data from DBase into non-delimited files and BCPed the data into a SQL db - HMS(Note that this db has the same t...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10066473.html
Zones:
MS SQL ServerDate Answered: 07/23/1998 Rating: 7.6 Views: 0
I am attempting to use the BCP command line utility with a database I have inherited. My problem is that it does not like the hyphen in the name of the database. I know ho wto rename, but what I ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10459356.html
Zones:
MS SQL ServerDate Answered: 06/15/2000 Rating: 7.8 Views: 0
Is it possible in SYBASE, to insert multiple records with a single command.
(For certain reasons, we do not want to do a BCP. )
The scenario is, I have a flat file. I have a PERL job which is ...
http://www.experts-exchange.com/Database/Sybase/Q_10472658.html
Zones:
SybaseDate Answered: 08/10/2000 Rating: 5.6 Views: 0
i'm trying to save a table to a csv file using a stored procedure. can anybody help me out?
CREATE PROCEDURE dbo.sp_bcp
AS
BEGIN
declare @workstring varchar(255)
select...
http://www.experts-exchange.com/Database/Sybase/Q_11345897.html
Zones:
SybaseDate Answered: 09/26/2000 Rating: 8.2 Views: 0
When i transfer record from a particular table to a text file through bcp utility,It will transfer complete length of field.e.g if field length is 25 it will transfer all 25 characters of each colu...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11353878.html
Zones:
MS SQL ServerDate Answered: 10/12/2000 Rating: 7.4 Views: 0
I know it is possible to sort the data when using bcp. Can someone provide me with an example.
Thanks,
Dipali
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20616613.html
Zones:
MS SQL ServerDate Answered: 08/29/2003 Rating: 7.6 Views: 0
It's been really bothering. I have to generate an interface file from my system. This will have @@HDRxxxx as the first row, then some detail rows, then @@TLRxxxx as the last row. I have a table int...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20928322.html
Zones:
MS SQL ServerDate Answered: 03/23/2004 Rating: 7.6 Views: 0
I am almost out of hair at this point. I have a relatively simple table structure:
CREATE TABLE [dbo].[DNS_Requests] (
[Ticket] [smallint] NOT NULL , [User_ID] [smallint] NOT NULL , [IP] [var...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21001926.html
Zones:
MS SQL ServerDate Answered: 05/27/2004 Rating: 5.6 Views: 8
Hi all
I want to use BCP to import a csv file into a sql table
so I have
a database called user
a table called temp
a csv file called c:\temp.csv - first line is the field names so I ne...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_21409269.htm...
Zones:
ASPDate Answered: 05/07/2005 Rating: 6.6 Views: 0
I am dumping data that I would like to import into Excel. Unfortunately, there are many newlines in the text fiels, so I am restoreing to the -r switch to change the record separator, so that the e...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21424451.html
Zones:
MS SQL ServerDate Answered: 06/17/2005 Rating: 8.4 Views: 0
