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

    ITKE392,095 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.

    ITKE392,095 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?

    ITKE392,095 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

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

    ITKE392,095 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,290 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...

    ITKE392,095 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!

    ITKE392,095 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...

    ITKE392,095 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!

    ITKE392,095 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.

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