• Is SQL case sensitive?

    Does anyone know if SQL case is sensitive (syntax). I'm using MySQL and SQL Server and I find that it's case in-sensitive in both. Thanks for the help.

    ITKE407,620 pointsBadges:
  • SQL (QMQUERY) date conversion issue

    I inherited a QMQUERY program that my user came to me today indicating that the week number was not correct. This query puts data into a workfile and a second query is called that splits other data into fields. As far as the two relevant fields are concerned, the second program does not modify...

    azohawk1,855 pointsBadges:
  • Create ER diagram in Oracle SQL Developer

    I'm fairly new to Oracle SQL Developer and I'm trying to create an ER diagram for my database tables. How can I go about this process? Any help would be appreciated.

    ITKE407,620 pointsBadges:
  • SQL average command for column IDs

    For SQL, does anyone happen to know if I can use the SQL avg() function for average by my column IDs? Basically, I have several different IDs and I'm trying to get the average of each through one query. How can I go about this?

    ITKE407,620 pointsBadges:
  • How to SQL update several records in a query

    In SQL Server, I have a table that's labeled this: config_name | config_value. I'm looking to update several records in one query. Here's what I have so far: UPDATE config SET t1.config_value = 'value' , t2.config_value = 'value2' WHERE t1.config_name = 'name1' AND t2.config_name = 'name2'; But...

    ITKE407,620 pointsBadges:
  • How can I stop the export process in SQL Developer

    I apologize in advance if this is a stupid question but does anyone know how to stop the export process in SQL Developer? Thanks!

    ITKE407,620 pointsBadges:
  • Copying SQL Azure database to development machine

    I'm looking to copy my SQL Azure database to my local development machine. I already have a development database in the cloud but don't want to pay for it anymore. I have copied by production database to the new development database but I need that same one on the local machine. How can I go about...

    ITKE407,620 pointsBadges:
  • PowerBuilder 11 in SQL 2008

    We are seeing performance issues with our PB 11 app after SQL 2005 DB was migrated to SQL 2008. We did not change any code just the connection profile. From: [Profile APP] DBMS = SNC SQL Native Client(OLE DB) Database=database UserId= DatabasePassword= LogPassword= ServerName=SQLServerName LogId=...

    Lstadler5 pointsBadges:
  • Create first database in Oracle Database 11g Express

    Recently, I installed Oracle Database 11g Express on my Windows 7 machine. Also, I installed Oracle SQL Developer too. Now, I'm looking to create a database with two tables, followed by using SQL Developer to add / query data. But when I opened Developer, it's asking me to make a new connection (I...

    ITKE407,620 pointsBadges:
  • Three ways to login in to SQL database server?

    Does anyone know what are the three ways to login in to SQL database server?

    melbourne5 pointsBadges:
  • SQL7919 Data conversion error

    Hi, I have an embedded SQL program in which I generate an XML element as a VARCHAR(256). This is done via: select xmlserialize( xmlelement(NAME "Name", 'Something') as VARCHAR(256) ) as XmlResult from sysibm/sysdummy1 The SQL statement is run via sqlcursor and I fetch the result into a RPGLE...

    mathypaesen10 pointsBadges:
  • Export Oracle SQL Developer query to CSV file

    I'm currently using Oracle SQL Developer and I need to export one of my queries to a text file. I would like it to be a CSV file. But I'm not seeing any export options at all. Even double clicking on the query itself didn't work. What should I do here?

    ITKE407,620 pointsBadges:
  • Confirm what version the Oracle Database is in SQL

    My partner and I are currently creating an installer for a new application. Basically, a user gets to select a data source for their configuration -> nominate what database it is. But here's what we have to do: Basically make sure that the database is Oracle / the version too (this will be done...

    ITKE407,620 pointsBadges:
  • How to substring and cast in select where statement on iSeries with RPG free

    Hi. I'm relatively new to free form RPG and I rewrote a program to be RPG free and SQL. I'm having problems with my where clause. I'm trying to substring the second byte on a 2 digit packed field. I've tried to use the CAST statement to convert the packed field to CHAR and then do the SUBSTRING on...

    raynesnf65 pointsBadges:
  • Duplicate record deletion using SQL/400

    Hi, How do I delete duplicate records using SQL/400 with SQL query please? Thanks!

    6r1,715 pointsBadges:
  • How can I change SQL language and date format?

    I'm using an older version of SQL Server (2005 to be exact). So when I try to execute, DBCC USEROPTIONS, it's giving me a foreign language and the date format DMY. I need the language to be in English / format in MDY. Is there a way to change this? Thank you very much

    ITKE407,620 pointsBadges:
  • Should I run a SQL view in my SQL Server database?

    For SQL Server, should I run a SQL view in my database? My friend told me to just run a stored procedure but I would rather run a view for security purposes. What should I do?

    ITKE407,620 pointsBadges:
  • Online report missing data that is in PDF

    When we view a report on Report Manager it shows 5 rows and a group count of 10. If you spool the report out to PDF or print it, it shows 10 rows and a count of 10. If you search online, the data in rows 6-10 cannot be found but they are there in the PDF and the printed version. Why is the data...

    AndreaFl15 pointsBadges:
  • SQL split column into multiple rows.

    I'm going nuts.. I have a table with 30+ columns. One of the columns has a string with serial numbers that are comma separated. What I'm trying to do is create a new temp table with the identityID and the serial number. This way I can add each parsed out serial number value to our production data...

    ToddN200043,965 pointsBadges:
  • RUNSQLSTM command failed

    I have created one member with SQL table type under which I have written create table query. But when I tried to compile program using RUNSQLSTM, it's showing RUNSQLSTM command failed. I am using pub1 demo server.

    nabamita75 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