• SQL: How to display the last name alone from the emp name where first name n lastname is in a single colum

    Is there a way to display the last name alone from the emp name where first name n lastname is in a single column?

    NARMATA50 pointsBadges:
  • SQL query replacing not in


    vscbobbadi5 pointsBadges:
  • How to change SQL editor coloring in Eclipse

    In SQL, I was able to change my syntax coloring in Eclipse preferences but my normal text still remains in black. Is there a way I can change the setting?

    ITKE440,640 pointsBadges:
  • ORA-00936 error with SQL NVL statement

    I'm using Oracle and I have this SQL NVL statement: select a.*, case when NVL (SELECT max(b.field1) FROM b where b.field2 = a.tbl_a_PK , 'TRUE') = 'TRUE' then 'has no data in b' else 'has data in b' end as b_status from a My SELECT is returning one value (as it should) but I'm also getting...

    ITKE440,640 pointsBadges:
  • How to execute a message in PL/SQL from SQL command prompt

    Sir, I have written a small message using PL/SQL. When I execute that query in SQL CMD prompt, I'm unable to see my output. How can I execute my output in SQL?

    kothias5 pointsBadges:
  • Execute SQL command to send .XLS file to certain email ID

    I am using EXECUTE SQL command to send a .XLS file to certain email ID. Now when I use TOSTMF in the statement, the XLS file is getting copied in the root directory also, which is not needed. Requirement is that only email should be sent. But if I remove the TOSTMF from the statement, the XLS file...

    Supriyoas400250 pointsBadges:
  • SQL Server: Getting the identity from an inserted row

    For SQL Server, how can I get the identity of an inserted row? Do I have to use @@IDENTITY or IDENT_CURRENT? Thanks so much for your help.

    ITKE440,640 pointsBadges:
  • SQL INSERT into a table using input from second table

    For the past week, I've been looking to INSERT into a table using input from my second table. Is there a way to do this in SQL? Maybe using a syntax? Thanks so much.

    ITKE440,640 pointsBadges:
  • How to use Oracle from a user connection to the end

    Please, I would like to know how to use Oracle from a user connection to the end. Or you can just explain a SQL execution to me to answer this question. Thanks!

    collines20125 pointsBadges:
  • Oracle: Find value for each UserID that has latest date

    In my Oracle table, I have three different columns: UserID, Value and Date. I'm trying to get the value for each UserID (that has the latest date). How can I do that? Can I use SQL?

    ITKE440,640 pointsBadges:
  • SQL problem: Order results in descending order

    I'm trying to create an SQL statement that produces a listing that shows how many students are coming from each city. How can I order the results set based on the number of students from city in descending order?

    nepal1234565 pointsBadges:
  • SQLState=01534 [SQL0181] when running DML instruction in System i Navigator

    Hello, I'd like to avoid the message SQLState=01534 [SQL0181]. This appears whenever I run a DML instruction in System i navigator or RDI or ... Thanks for helping! Mathy Paesen

    mathypaesen10 pointsBadges:
  • SQL error message when creating procedure containing three cursors

    I have created a procedure containing 3 cursor. It gives me the below error and when I add @delimiter ++; at start and end it gives message that "command processed" but doesn't show output. Any suggestions? [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601,...

    rockstar185 pointsBadges:
  • SQL Express 2008: Gain administration rights

    Recently, I got a Windows 7 PC from a friend that has an existing instance of SQL Express 2008. I already have local administration rights but I don't know the SA password. So I can't create databases or modify the password. How can I get SYSAdmin privileges? I tried using SSMS but it didn't work....

    ITKE440,640 pointsBadges:
  • Finding data from a table that is linked with another table using foreign keys

    I want to see all the customer names and their city who have an account in a specified bank. Problem is my customers are listed in one table and accounts are listed in another. But I do have another table called depositor where it only store account name and customer name. How can I see customers...

    Rezoan5 pointsBadges:
  • Find the list of SQL statements run by a particular user on iSeries server

    How can I find the list of SQL statements run by a particular user on iSeries server?

    JohnsonMumbai1,365 pointsBadges:
  • Create SQL script for insert statements / table having blob data

    How can I create a SQL script for insert statement / table having blob data?

    sushantmane15 pointsBadges:
  • How to spool dynamic filenames from SQL script

    I need to get different file names each time I run the script. How can I do that?

    01129225 pointsBadges:
  • Monitor progress of SQL file

    I'm trying to import a pretty large SQL file (roughly 6 GB) to my local database. Here's what I'm using: $ mysql -h localhost -u root 'my_data' < foobar.sql $ mysql --version /usr/local/mysql/bin/mysql Ver 14.12 Distrib 5.0.96, for apple-darwin9.8.0 (i386) using readline 5.1 So, I'm wondering if...

    ITKE440,640 pointsBadges:
  • Timing SQL queries with PSQL

    I'm using a PostgreSQL database and I have to benchmark several SQL queries against it. Would there be a way I can actually 'time' my queries using PSQL? Thanks!

    ITKE440,640 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.