• Connection of Crystal Report 2008 with VB6.

    Please let me know the procedure to bring the controls of Crystal Report 2008 in VB6? What control has to be select and what coding should be use for the same? I'm using SQL 2000 as a back-end. Please help.

    Anishrohlx5 pointsBadges:
  • How do you load a CSV file into Oracle?

    How do I load a .CSV file into Oracle?

    Dolly275 pointsBadges:
  • Experience applying SP4 to SQL 2005?

    Hi, I have a Microsoft SQL 2005 SP3 database server with 2 instances (both patched to SP3.) The one instance (1a) includes 52 small production databases. The other instance (1b) includes 2 large production databases. Now I would like to upgrade the (1b) instance to the new Service Pack 4. The way I...

    CarlMarius15 pointsBadges:
  • Can I select 10 rows randomly in MySQL?

    What's the best way to write a query that can select 10 rows randomly from a total of 800,000.

    ITKE346,060 pointsBadges:
  • Can I replicate the ROW_NUMBER() in MySQL?

    Does anyone know of a way, in MySQL, to replicate a SQL Server function "ROW_NUMBER()?"  Here's my example: SELECT col1, col2, ROW_NUMBER() OVER (PARTITION BY col1, col2 ORDER BY col3 DESC) AS intRow FROM Table1 With this, I would be able to add a condition to limit "intRow" to 1 to get a single...

    ITKE346,060 pointsBadges:
  • How to create a MySQL pivot table

    I currently have a MySQL table that looks like this: company_name action pagecount ------------------------------- Company A PRINT 3 Company A PRINT 2 Company A PRINT 3 Company B EMAIL Company B PRINT 2 Company B PRINT 2 Company B PRINT 1 Company A PRINT 3 But now I need to run a SQL query to get...

    ITKE346,060 pointsBadges:
  • How to check if a table exists in MySQL without throwing an exception

    Does anyone know if there's a way to check if a table exists in MySQL (possibly through PHP) without throwing an exception? It's not beneficial for me to parse the results of "SHOW TABLES LIKE." There must be some sort of query I can use.

    ITKE346,060 pointsBadges:
  • Multiple numbers for the same part in Microsoft Access

    I have 3 relating part numbers for the same part with the same description. How do I enter them into an Access DB for tracking?

    vaustin5 pointsBadges:
  • Getting error when selecting triggers to display in System I Navigator

    I keep getting an error when selecting triggers to display in navigator: sql0205 Eventdelete not in table systriggers in qsys2.

    Pgmr4660 pointsBadges:
  • Creating forms with PHP and MySQL

    Using PHP and MySQL, I am trying to create a table form which can input multiple data within the form. When the space row provided is not enough, I want to add in another function which can help add rows in the same table. How can I do this?

    MarkG7135 pointsBadges:
  • Download from the AS/400 tab delimited file

    I need to be able to download in an automated fashion, a DB2 table as a tab delimited text file on a PC. I have successfully done this manually using the Actions munu in client access but need to be able to do it automatically in either a CL of a PC scheduled job so that it will run unattended. Any...

    Butcheanes5 pointsBadges:
  • How do I save pictures in database VB.NET

    I'm using SQL Express to develop application which have I pictures so I can try how a save picture inside database and loading VB picture box. Can anyone tell me please? How do I do this?

    12345678900110 pointsBadges:
  • Is it possible to randomly select rows in a SQL Server database?

    I've been using SQL Server 2005 and in my database, I have a table labeled "customerNames" which has two different columns (ID and name). It has around 1,000 results. I've been trying to create a function that allows me the capability to select five different customers randomly every time. Would...

    ITKE346,060 pointsBadges:
  • Pulling a list of triggers in a SQL Server database

    I'm trying to get a list of triggers in a SQL Server database with the table name and the table's schema. Here's what I have so far: SELECT trigger_name = name, trigger_owner = USER_NAME(uid),table_schema = , table_name = OBJECT_NAME(parent_obj), isupdate = OBJECTPROPERTY( id,...

    ITKE346,060 pointsBadges:
  • Exporting a SQL database to MySQL

    I have a MS SQL .BAK database that I need to convert to MySQL. I was able to import the database but not actually export to MySQL. A friend of mine told me to use MySQL Migration Toolkit but it's been replaced by MySQL Workbench. Can I use this tool to migrate the database? Or is there another way...

    ITKE346,060 pointsBadges:
  • How to create a database table from XSD files

    I have a bunch of XSD files (from which I get data access classes, stored procedures, among other things). But now I need to generate a database table from these and I don't know how. Anyone know of a tool than can generate DDL statements? I would appreciate some help.

    ITKE346,060 pointsBadges:
  • odbc as/400 connect to mysql

    I am trying to figure out how to get data from the as/400 into mysql

    Sunnyday25 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?

    ITKE346,060 pointsBadges:
  • Export flat file data as .txt

    I have data in a flat file that I want to send to an external server in text file format. How can I do this within a RPGLE or CL program?

    LarryL707830 pointsBadges:
  • Access Forms

    Can information appear on a form based on information on a table? I have information on a table that I want to appear on a form, but I want the info to change on the form based on a change made in the table. EG I have a person down on a rota as doing an overnight, the name will change each night,...

    quinny5 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