• Converting VFP9 DBF to MS SQL

    Are there tools available for converting VFP9 DBF to MS SQL? Or what is the best approach? Thanks!

    B385 pointsBadges:
  • Linking to a table in SQL with Visual Basic

    How could I link to a table in SQL using Visual Basic?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQLRPGLE – How to override data set data structure at run time

    I currently have an SQLRPGLE routine that receives a SELECT statement as a parameter and then fetches the data set into a data structure based on the file. This only works over a single file as the datastructure is created at compile time and has to be based on filea. I would like to make this...

    NarkedDiver20 pointsBadges:
  • Receiving a DOS output with a Visual Basic script in SQL

    I would like to solve this following complex script in SQL by using Visual Basic, either version 5.0 or 6.0. My first table name is tblClient, with fields ClientID and ClientName. My second table name is tblPurchase, with fields ClientID, Item Name, Qty and Price. I would like to pass one SQL query...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL query for employee salaries

    How to display the third and seventh employee salary details in SQL?

    Rekha0 pointsBadges:
  • SQL – Pass the result of the first query as the second query select column name

    I want to pass the result of a SQL query as the column name in another query eg. (note there will be a single result for the first query): SELECT CASE WHEN fld_type1 = 'A' THEN 'VAL_ALPHA1' WHEN fld_type1 = 'D' THEN 'VAL_DATE1' ELSE 'VAL_NUM1' END AS FIELDNAME FROM TABLE1 I want the result of the...

    Chris12325 pointsBadges:
  • SQL Macro to populate a form

    I need a SQL macro to populate a form? Please help.

    SAS70ExPERT125 pointsBadges:
  • SQL Server datetime

    Hi - When I run this: select cast ('461129' as datetime). I get 2046-11-29 00:00:00.000 instead of 1946-11-29 00:00:00.000 Can you please let me know why and what I need to do in order to get the required results? Thanks.

    DBM10 pointsBadges:
  • 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:
  • Using Query/400 to create SQL-style GROUP BY

    Greetings and salutations, I'm trying to put together a query for one of my users to track sales numbers and it is starting to give me a headache. I've put together a query using Query/400 with a break at each invoice to sum the dollar amount for each one. The issue is that on many of our invoices,...

    Kyoojin0 pointsBadges:
  • SQL/400 field editing

    What is the best (easiest!!) way to add editing to fields in an SQL-created table?

    DanTheDane2,555 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:

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