• SQL tutorial?

    Hi, I am having some difficulty in interpretation of SQL questions. I am trying to learn the language self taught is there some interactive tutorial I can try.

    Lystra10 pointsBadges:
  • Need a COBOL QMHRTVM Example

    Does anyone have a code snippet they would be willing to share that demonstrates the parameter setup and the call for the API QMHRTVM? I am lousy with API's but I need to incorporate this one into two of my SQLCBLLE Programs.

    FCARPENTER200 pointsBadges:
  • SQL Server 2005 or SQL Server 2008

    I have been trying to learn SQL 2005 from like a month or two and i think I have done a good job. Now I was about to try some security stuff in it but I saw that SQL 2008 is in market. Can any body suggest me that what is the difference between the two and can I switch to SQL 2008? What ever I...

    JrSoftwareDeveloper5 pointsBadges:
  • SQL statements question

    I have an accounts ENTRY table with many fields like (ac_bal, ac_id , ac_date, ...etc) and I want to retrieve the summation of each account in each month as seen in the table below. 10-01 21-04 02-11-4 ..... jan Feb mar . . . Etc. Can anyone help?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Migrate MySQL database to SQL 2005

    We are looking to migrate from MySQL to a full blown iteration of SQL 2005. Are there tools in place that will allow us to migrate our data and tables or are we on our own for getting our data into the MS database?

    Karl Gechlik9,860 pointsBadges:
  • Directory command is not working

    Call qcmdexc parm('CPYTOIMPF FROMfile(mylib/myfile) TOSTMF(/home/test/test.txt)') It is not working I think because of the missing ' I tried to fix it with a hex value of x'7D' but the run SQL procedure didn't accept it

    Blueye20 pointsBadges:
  • SQL update command to update certain digits in a row of a column with VARCHAR2(9) DATATYPE.

    Please I need an SQL command that I can use to update only the fourth and fifth digits in a particular column in an Oracle 9i database.The column has a VARCHAR2(9) datatype. My Oracle database is on Windows 2003 environment. Eg: The row in question reads '063150987' and I want to replace the fourth...

    IdongesitDaniel5 pointsBadges:
  • Oracle 9i installation

    Hello guys I have recently started learning SQL and I am trying to install 9i (database or software where I can practice SQL quires). Long time ago I started learning SQL on that time it was personal Oracle 7 I installed and used to do my practice but now I have heard that you can install 9i on...

    11g5 pointsBadges:
  • Would like to learn SQL. Which vendor should I go for and what certification should I get?

    Hi All, I would like to learn SQL but was wondering shich SQL package should I go for? I am looking for employment in the finance industry as an analyst and thus looking for the right SQL package to learn and get the right certification. Could someone please advise me accordingly. Cheers! Jeevan

    Jeevan231015 pointsBadges:
  • SQL Writer error

    SQL error in the start; either mesup or tempered. What should I do?

    Chuanilee5 pointsBadges:
  • SQLCODE and SQLSTAT error messages?

    Does anyone know where I can find SQL CODE and SQL STAT error numbers and messages?

    Vince0125 pointsBadges:
  • SQL in an SQLRPGLE program

    I want to use embedded SQL in an SQLRPGLE program to search a file for a field entered in a screen to select data using the LIKE operand. This is my code C/EXEC SQL C+ DECLARE C1 CURSOR FOR SELECT * FROM F0101JN WHERE ALADDZ = :SZIP C+ AND ABALPH LIKE :SINNME ORDER BY ABAN8 C/END-EXEC * I entered...

    Alpfalpf25 pointsBadges:
  • How do I retrieve data from Visual Basic 6.0 with SQL?

    How can I retrieve data in VB 6.0 from SQL?

    Escabarte5 pointsBadges:
  • SQL code -727

    Does anyone know what -727 SQL return code is?

    Bebiii15 pointsBadges:
  • Using SQL code to read a filename

    Can you write a SQL query that will read PDF filename from a dir and then match the filename to a data element in a table having the same name? For instance, the filename is 12345.pdf where 12345 is actually an invoice number. Can the query read the filename and then locate the same invoice number...

    Teedee5 pointsBadges:
  • What is the difference between DBMS, RDBMS and SQL?

    What is the difference between DBMS, RDBMS and SQL?

    kapilsharma5 pointsBadges:
  • SQL Report Help

    Hi I'm dave and I'm new to the forum, SQL and SSRS. Thanks in advance for your assistance and patience. I have a recall report that produces letters for every patient who needs to return to the office on a certain date based on their recall plan (a plan that determines when they should return based...

    Blowinup5 pointsBadges:
  • When do I use a collection instead of a table in Oracle

    I am an old MS SQL server guy and I am doing some work in oracle 10G. Most of what I am doing is all set manipulation(insection between two dataset) My first instinct would be to use temporary tables and use a not exists. I was wondering if that is the most efficient way in Oracle. I read about...

    Kmaccrimmon5 pointsBadges:
  • Adding files to TempDB

    Do I need to restart SQL Server 2005, if I have added additional files to the TempDB?

    SQL Server Ask the Experts2,585 pointsBadges:
  • DB2 to SQL conversion

    How to I convert DB2 to SQL?

    cgardel015 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