• Data Source in SQL

    What is the data source in SQL

    botauk15 pointsBadges:
  • How to left or right justifying a text file

    Hello programmers. I am using sql to create a table from stored procedures and then streamwriter in vb.net to create a text file based on the sql table. Where and how do I control the right or left justification of the records in the text file? Thx.

    Ilfoprog50 pointsBadges:
  • Case statement with Strings in a SQL statement

    I have a SQL statement that DOES work to create a bit of a pivot table. select JOB#, sum(CASE when COURSE#=’36’ then MONTHS  end) as “Training” from FILE where group by JOB# However, what I need is instead of showing the sum of the months, I want to show the string field on if it was...

    spishane25 pointsBadges:
  • Questions around SQL

    What is data modeling? Why is the data modeling important? What makes a good data modeling? Where do data models fit in? Who should be involved in data modeling? And why? What is database? What is DBMS? What is RDBMS? What are advantages to using DBMS? What are disadvantages to using DBMS?

    shravangudikadi12310 pointsBadges:
  • Running AS/400 query

    SQLCODE -104 while preparing statement in SQL . Eval Sqlstmt1= 'Insert Into' + ' ' + %Trim(WRKTLIBR) +'/' +%Trim(WRKFILE) + ' '+'(Select * from '+ %Trim(WRKLIBR) + '/' + %Trim(WRKFILE) + ' ' + 'A' + ' ' + 'Where Exists (Select * from CSTBYUNQL1 B ' +' Where B.Compny = A.' +%Trim(WRKCMP) + ' and '+...

    abhisheka1405 pointsBadges:
  • SAP on SQL Server and NetApp

    Hi everyone, we are looking for some feedback from anyone who has used NetApp with SAP running on a SQL database. We are researching white papers, etc., but would really like to hear from some folks with hands on experience. What has your experience been like? Any performance hits? Any caveats or...

    DebDonohoe5 pointsBadges:
  • SQL Agent in SQL environment?

    What is SQL Agent in SQL Environment?

    Prcvjr220 pointsBadges:
  • Run Oracle 9i with Windows Server 2003 Domain Controller

    Sir, I have Windows Server 2003 server with DC. I just want to install Oracle 9i server on that server and configure client on Windows XP client side. I want to run Oracle 9i client through domain user. Is there any setting or rights of domain user that the user will be able to run oracle...

    Swapnesh15 pointsBadges:
  • Where is the best site to learn SQL?

    Where is the best site(s) to learn SQL? A place with example coding etc...

    JHAMLW5 pointsBadges:
  • SQL with Windows Vista home premium 32-bit

    Can I install SQL programs in Windows Vista home premium 32-bit?

    Mayo5 pointsBadges:
  • On the AS/400 iSeries can one use SQL queries to update file

    Cobol uses some kind of IKJ module user exit to allow DB2 SQL calls. I want to make a keyed read update one field and go on to the next record and do the same until end of file. Can do the same using RPG and if so could give me an idea what the code would like. How would the updated file be...

    nitzinger385 pointsBadges:
  • 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:

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.