• Convert hexadecimals to decimals in Oracle SQL

    For Oracle SQL, can I convert hexadecimals to decimals (and possibly back again if need be)? I appreciate the help available.

    ITKE828,160 pointsBadges:
  • Can two foreign keys reference the same primary key that is team table and fextures table having team a and team b referencing the team table primary

    Can two foreign keys reference the same primary key on another table. That I have team table attributes (Team_id, Team_name, Team_captain) and fixtures table having this attributes (Fixtures_id, fixture_time, fixture_date, fixture_venue, 1team_id, 2team_id). My question is this: Is it possible for...

    jupake15 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=...

    Lstadler15 pointsBadges:
  • Add comment to SQL code in MySQL

    One of my co-workers sent me a SQL code and I need to add a comment to it. Is there a way to do that? This is currently for MySQL. Thank you so much.

    ITKE828,160 pointsBadges:
  • Find SQL database table in Java

    I'm using both SQL and Java. Now, in Java, is there a way I could find out if a table exists in my SQL database? Do I have to write a query for this?

    ITKE828,160 pointsBadges:
  • SQL query for max 5 salary from each month separately

    I need a SQL QUERY to select highest 5 salary of employees in each month separately. Can someone help?

    ASWATHY12345 pointsBadges:
  • adding partition to existing non-partitioned table

    Hello all! I have a tables without partitions and I now want to partition it. How do I go about this? I tired alter table ... add partition... but it errors with "ORA-14501: object is not partitioned " So I tried to re-create the table with partitions: create table quote_header_test as select *...

    Skovac0 pointsBadges:
  • Error message when importing SQL file: MySQL server has gone away

    I recently tried to import one of my large SQL files through phpMyAdmin but this odd error message keeps popping up: MySQL server has gone away. What does that mean? What can I do about this?

    ITKE828,160 pointsBadges:
  • Update table in Database through linked server

    I want to update my TableA on my ServerA by using linked server which is on serverB.I have successfully created the linked server but i am a little bit confused. Actually i have to update a columnA of TableA from the data coming from columnB(TableB) of linked server on the basis of the matched...

    hussainahmad15 pointsBadges:
  • Remove last character in T-SQL string

    Is it possible to remove the last character in a T-SQL string? So for example, I have this: STRING I want to have this: STRIN Thanks!

    ITKE828,160 pointsBadges:
  • Insert values from one SQL table into a second one

    In SQL, can I insert all of the values from one table into another one? Can I just used the INSERT statement for this? Thanks!

    ITKE828,160 pointsBadges:
  • Database Admin…

    Will the real DBA please standup! Is there a forum just for DBAs? I got started in 1995 when a recruiter asked me if I wanted to be a DBA on an AS/400? Was I surprised! However, the shop that hired me did not understand what a DBA on AS/400 really did... nor did I. Well, I ended up doing security,...

    Znason460 pointsBadges:
  • 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.

    ITKE828,160 pointsBadges:
  • Duplicate record deletion using SQL/400

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

    6r1,850 pointsBadges:
  • Select SQL date without time

    When I'm trying to select a date in SQL, it keeps giving me this: 2016-06-05 20:17:33:933. Here's the thing: I actually only need the date (not the time). Is there a SQL command for this?

    ITKE828,160 pointsBadges:
  • Get first character of SQL column

    Currently in SQL, I have a column with a length of 6. In that specific column, I need to get only the first character. How can I do that? Is there a SQL String function?

    ITKE828,160 pointsBadges:
  • Recover unsaved scripts after SSMS crash

    Our SSMS just crashed and I have to recover a bunch of unsaved scripts. Is there a way to do that? Any help is appreciated.

    ITKE828,160 pointsBadges:
  • How do I run and import a large .SQL file?

    I've been using RedGate Software for SQL data comparisons and it turns the data into a .SQL file (this is for running on another machine). Here's my issue: It's a pretty large file so copying and pasting won't work and when I try to open it in SSMS, I always get the error message that it's too...

    ITKE828,160 pointsBadges:
  • SQL: Avg function for calculating the age of a man and woman in different columns

    I would like to use avg function for calculating the age of a man and woman in different columns but as a total in each case. Could you help me" For instance, Select Sum(case when woman then '1' else '0')woman Sum(case when men then '1' else '0')men Avg(birthday woman)avg1 Avg(birthday men)avg2

    pe444000hhhhh5 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...

    azohawk2,060 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.

Thanks! We'll email you when relevant content is added and updated.

Following