• Help on Bulk insert and xp_cmdshell rename

    Hi, I have a csv with only one field with multiple rows, when i am using bulk insert to insert into sql server table, all the rows are inserted in to single column instead of multiple rows. I don't have a delimiter. csv file: (First row is blank) apple bat cat doll when I used the below command:...

    GIG240 pointsBadges:
  • How do I Autopopulate a few field on my my form?

    I have a database created in Access 07 and in this database I have tables, forms and reports. I have a table where I have all the Plan info and I also have a table into where the info is stored after being entered on the form. On my form I have a plan number, plan name what I want to happen is when...

    Lisarod25 pointsBadges:
  • How can I reset a sequence in Oracle?

    Does anyone know how to reset a sequence in Oracle? I know that in PostgreSQL, I used this: ALTER SEQUENCE serial RESTART WITH 0; Is there anything like this in Oracle?

    ITKE352,580 pointsBadges:
  • How do I duplicate or clone a dying SATA drive?

    If a sata drive is dying what is the best method to duplicate or clone it without risking the data? Is this the same for ide or scsi drives? If not please list the best methods for these as well across any platform.

    ITKE352,580 pointsBadges:
  • DB2: Optimizer not using any indexes

    I have DB2 version 8.2 installed in AIX one thing I am seeing is strange that optimizer not using any indexes. In any simple join index are not being used. Is there any parameter which needs to be set up?

    AS400 - Ask the Expert485 pointsBadges:
  • Bundling MySQL Community Edition

    Is it free to Bundle the MySQL Community Edition within our Product or along with our Product CD/DVD? Do we need expose the source of whole application software or product to the community? Our product is our main bread/butter of the company. Let me know what options are avaliable and how to do it.

    Rajeshbs45 pointsBadges:
  • Catching an uncaptured error in SQL

    This is a batch of SQL code I’ve been using: BEGIN TRY begin BULK INSERT DBXMRPAS2.dbo.[STG_drive] FROM '\Wdmyitpxmdev1xmmsbcpcsvfile20080715drive.200807151100.extracting' WITH ( MAXERRORS =1000, FIELDTERMINATOR = '^', ROWTERMINATOR = '|n' ) end END TRY BEGIN CATCH SELECT 'Error Caught' SELECT...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to convert a csv file into a xlsx one?

    Hi, I'm generating a csv file from an open hub in BW so I need to convert it into a xlsx one due to I need to upload it into the Microsoft SharePoint. Is there an abap function that does it? I know that there is one to convert an xls one into a csv. Thanks

    VPD5 pointsBadges:
  • Can we use count on count or avg on avg for aggregate functions?

    Can we use count on count or avg on avg? Meaning can we nest the aggregate functions...if yes...then how?

    niky12345 pointsBadges:
  • Trigger for DB2 user administration

    Hi guys, I want to create trigger to avoid users updating records or when he update that data want to write one log file with his Login ID, time, date etc. Please help me. If these is possible using trigger then please tell me how? Thanks Amar

    Meetamar15855 pointsBadges:
  • Database hanged due to concurrence

    Hi to all. We have an application running under Windows 2003 Server, database SQL Server 2000, client/server, 60 users updating or consulting data. We did a concurrence test. We asked several users to search for same string at same time and the database got hanged. Will that be a configuration...

    Ome0015 pointsBadges:
  • Inserting multiple rows in Oracle 10g

    I need to insert multiple rows of data into multiple tables from one temporary table. I need to put some of the columns into one, some into another, and the remainder into another table. I realize I will need to create INSERT statements for each table insert. Is there an easy way to select specific...

    Ora mer20 pointsBadges:
  • Customizable IT software for examination process and question database

    Thank you in advance for your helpful replies. I am interested in hiring an IT company to create a custom software that facilitates the examination process we offer at our school. However, I am unsure of what exactly is needed so I was hoping for assistance: The goal is to have an online secure web...

    VivTL5 pointsBadges:
  • Convert OpenOffice Base to Microsoft Access

    Is there a way to convert an existing OpenOffice Base database to MS Access?

    Naomih15 pointsBadges:
  • Filtering a Subform

    How do I filter a form based on a value contained in the subform?

    Johnandy5 pointsBadges:
  • How can I split CSV strings in Oracle 9i?

    I'm trying to to split several CSV strings in Oracle 9i but I'm running into a few issues so I have a couple of questions: Is this possible in Oracle 9i? Do I need to create a new data type? Would I be able to declare the type within the function? Thank so much!

    ITKE352,580 pointsBadges:
  • MS-Access linked table to AS/400 file – can’t retreive field descriptions/headings

    I have created a linked table in MS-Access 2003 over an AS/400 file.  It works pretty well so far.  The problem I have is I only get field name and type.  I don't get any field description or heading information form the file. Any suggestions on how I can retrieve the descriptive info as well?

    MBERIC120 pointsBadges:
  • Cloning C and G drives on Windows Server 2008

    I need to clone my C drive and G drive on a Windows server 2008. The C drive is a mirror and the G drive is a 6 disk raid 5. What is my best option for cloning this setup?

    TeachMeIT975 pointsBadges:
  • Flat file or Physical file in as/400?

    How to know whether a file is physical file or flat file in CL/400?

    Alicsc370 pointsBadges:
  • Database Newbie

    I'm quite new to database security and MS SQL server 2005 and 2008 and was hoping to find some extra sites or books to help as I am currently writing an application to send OS info and service tags to our SQL server. I obviously can t have the SQL server directly on the internet with an open port...

    Neutrino50 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following