• How to clone an Oracle user

    I have to clone an Oracle user but I'm not sure of the process. Is there a SQL query to do this? Basically - this user will have the same privileges but just with a different username. Thank you.

    ITKE434,585 pointsBadges:
  • Halt running MySQL query

    Each day, I usually connect to MySQL from a Linux shell. Every once in a while, by accident, I run a query that's way to big and I have to stop it. When I tried Ctrl+C - it stopped all of MySQL and I have to reconnect. Can I just kill this one specific query? Thank you so much.

    ITKE434,585 pointsBadges:
  • How can I enable the MySQL query log?

    Would I be able to enable the MySQL query log function so each SQL query statement that we received from our clients is logged correctly (including time)? Can I use phpMyAdmin to do this? Thank you.

    ITKE434,585 pointsBadges:
  • SQL Server: Remove foreign key

    On my SQL Server, I have to remove the foreign key from one of my tables so I can insert different values. What SQL query should I use for this? Thank you very much for your help.

    ITKE434,585 pointsBadges:
  • Benchmark a SQL Server query

    Would there be a way I can benchmark a specific SQL Server query? I don't want to 3rd party tool either. Would SQL Profiler work for this?

    ITKE434,585 pointsBadges:
  • Needed help with SQL query involving password column in a table

    Hi, I have a requirement like I need to create a table with password column which should have any of the numbers between 0-9, any special symbols, alphabets. It should contain all the three combination. If the user try to insert missing any one should throw inserting error.

    vinu54615 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:
  • 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:
  • How can I get a list of SQL Server queries that are running?

    Would anyone happen to know if there's a way I can get a list of queries that are currently running on my SQL Server? I noticed that I have a large query that's running on one of my database servers and I have to stop it. Thanks!

    ITKE434,585 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:
  • #1064 Database importing error

    I am getting this error when I import the database in phpMyAdmin. Only few tables is imported. SQL query: <!-- PMA-SQL-ERROR --> <div class="error"><h1>Error</h1> <p><strong>SQL query:</strong> <a...

    afaf915 pointsBadges:
  • SQL query: Fetch all records from date field

    Hi, How to fetch all records from the date field less than current date's records provided date field format is centuray(C):YY/MM/DD Thanks.

    6r1,850 pointsBadges:
  • How to find 10 sequencing date for today in SQL query

    It's like date 1 2 3 4 5 6 7 8 9 10 with month and year. How can I do this using a SQL query?

    sundramkharya5 pointsBadges:
  • Display only the duplicate records in SQL

    I need a query to display only the duplicate records alone. For an example, distinct filtr the duplicate records and displays the actual record. Here I need only duplicate records.

    NARMATA50 pointsBadges:
  • SQL query replacing not in

    I wrote this query with not in replace the not in with not exist. SELECT LASTNAME , TITLE FROM NOR_EMPLOYEES WHERE EMPLOYEE_ID not in (SELECT E1.EMPLOYEE_ID FROM NOR_EMPLOYEES E1,NOR_EMPLOYEES E2 WHERE E1.EMPLOYEE_ID=E2.REPORTS_TO);

    vscbobbadi5 pointsBadges:
  • SQL Query: $DB_UPDATEABLE

    What can I do with this SQL query? $db_updatetable = new Database(); $db_updatetable->connect(); $db_updatetable->update(FUND_SUMMARY,$fval,'bank_name="'.$fval['bank_name'].'Query

    karthi3232875 pointsBadges:
  • Run SQL query with CSV format

    I'm trying to run a SQL query from my Linux command line and getting the result in a CSV format. Here's what I have so far: mysql -u uid -ppwd -D dbname << EOQ | sed -e 's/ /,/g' | tee list.csv select id, concat("\"",name,"\"") as name from students EOQ And here's my issue: The columns that...

    ITKE434,585 pointsBadges:
  • Removing MySQL rows from a table using SQL Query

    In MySQL, I have a table that currently holds the following topics: id url title company site_id So I have to go in and remove the rows that have the same title, company and Site_ID. Can this be done using a SQL Query? Thank you!

    ITKE434,585 pointsBadges:
  • SQL Server: Use N prefix before string

    In SQL Server, should I use the N prefix before string for my Transact SQL query? I'm working with a new database and I'm not getting any results back using this: SELECT * FROM a_table WHERE a_field LIKE '%а_pattern%' But, when I add the N prefix before %a_pattern%, it works. Appreciate the help.

    ITKE434,585 pointsBadges:
  • SQL Server: Query is filling up TEMPDB database

    I'm using SQL Server and my partner and I need to figure out how we can identify which query / stored procedure continues to fill up our trans log in our TEMPDB database. It's really starting to become an issue. Thank you.

    ITKE434,585 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