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

    ITKE435,910 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.

    ITKE435,910 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?

    ITKE435,910 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....

    ITKE435,910 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,360 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...

    ITKE435,910 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!

    ITKE435,910 pointsBadges:
  • Create DropDowns and populate ASP.NET

    I am trying to build a asp.net application with C#. It has a gridview in it that contains dropdownlist. I am looking to have a SQL query run that returns a record set. Lets say it returns 10 items. It should create 10 new rows (which it does). Then it should populate each one of those drop downs...

    cgashlin5 pointsBadges:
  • Executing SQL against all databases on a single server

    I have a SQL that runs against several databases on our server that helps diagnose issues. Here's what it is: select so.name, so.type, MAX(case when sc.text like '%remote%' then '' ELSE 'N' END) AS Relevant, @@ServerName as Server, DB_Name() as DBName from sysobjects so with (nolock) join...

    ITKE435,910 pointsBadges:
  • Listing all schemas in PostgreSQL

    I'm using PostgreSQL and I need to figure out how to list all schemas using SQL. Can anyone help me? I tried using the below code but it didn't work. SELECT something FROM pg_blah; Thanks!

    ITKE435,910 pointsBadges:
  • Copy SQL stored procedure from local to live database

    Hello, I want to copy multiple procedures from a local database to a live database?

    vikasbhatt25 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