• Rename SQL database table

    For my SQL database, I have to rename one of my columns. What's the process to do that? Will a specific query work for this? I just have to change the name.

    ITKE409,100 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:
  • SQL database rollback query

    How do I roll back in case the database changes all data to the same information?

    twatonny015 pointsBadges:
  • SELECT hex in SQL shows error

    I am a python student. this instruction: SELECT hex(User.name || Course.title || Member.role ) AS X FROM User JOIN Member JOIN Course ON User.id = Member.user_id AND Member.course_id = Course.id ORDER BY X When I run it shows invalid syntax. I am taking a python course but I know very little about...

    cmorenme5 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?

    ITKE409,100 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!

    ITKE409,100 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!

    ITKE409,100 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.

    ITKE409,100 pointsBadges:
  • Duplicate record deletion using SQL/400

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

    6r1,765 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?

    ITKE409,100 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?

    ITKE409,100 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.

    ITKE409,100 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...

    ITKE409,100 pointsBadges:
  • SQL: In responsiblity wise last 5 transactions details request as on 31.03.2016

    AS per audit review request: All responsibility wise  AP, AR, GL, CM , FA , PO, Inv last 5 transactions taken from the sql as given date for 31.03.2016.  Please help on our request.

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

    azohawk1,865 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.

    ITKE409,100 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