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
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
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 Grade: C 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 Grade: B 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
what is bcp.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20182547.html
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
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
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
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 Grade: A Views: 0
