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

    ITKE440,705 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!

    ITKE440,705 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:
  • SQL fetch returns no data

    My SQL select statement returns data, but an almost identical fetch does not, although the SQL code is 0, sqlstt is '0000', and sqlwarn is all blanks. What am I doing wrong? dcl-ds prtsplds; outnam char(10); libnam char(10); nofils char( 5); writer char(10); status char( 3); end-ds; exec sql...

    cslackman5 pointsBadges:
  • How do insert many images (BLOB) into a SQL Server table

    How do I insert several images (BLOB) in to a SQL Server table?

    cjohnNewVIc5 pointsBadges:
  • Generate multiple reports in SQL

    Dear Tech, this is Mushkin from Hyderabad, India. I have MS SQL data. I want to generate Multiple Reports in one Report. I tried myself but with no success. Please help me with this. I send you data. I used technologies including: Visual Basic 6.0, MS SQL 2008 and Crystal Reports 8.5.

    Mushkin5 pointsBadges:
  • Automating a SQL query

    I want to run a SQL query automatically and getting the output in Outlook from remote desktop daily. How do I automate it?

    ansarkhan5 pointsBadges:
  • Informix SQL Update using an inner join

    I have a need to update 270,000 records with a particular flag. Using temporary tables and multiple update queries I have creating a staging table to put the original value and the new value. So the table structure is like this: ID ORIG_VALUE NEW_VALUE 1223 A B 1234 D A 1334 ... I'm struggling with...

    bloucks5 pointsBadges:
  • New Embedded SQL to pull data from 1 DB to another is failing

    We just started using a TEST DB2 machine for the first time, for the past 20 years we've simply had test libraries on the Production DB2 box. Whenever I needed test data before, I just ran a CL I had created to copy *REPLACE the selected files. Our DB2 administrator is refusing to allow DDM to pull...

    MaryKyrrynMathias75 pointsBadges:
  • PL/SQL and Excel

    Hi, Is it possible to execute Excel Macros from PL/SQL procedure ?

    Gleferrec0 pointsBadges:
  • Execute SQL SELECT via RUNSQLSTM error

    Trying to execute SQL-statement "SELECT * FROM mylib/myfile" give errormsg SQL9010. Some say that SELECT is not supported with RUNSQLSTM, but IBM command parameter text indicates otherwise. Is SELECT supported and what am I doing wrong?

    DanTheDane2,555 pointsBadges:
  • Export SQL Server database to SQL script

    For my SQL Server database, is there a way to export it to an SQL script? I need something like mysqldump. It would take the database's name, and create a script that will remake the tables, data, stored procedures, etc. Does anyone know of anything like this?

    ITKE440,705 pointsBadges:
  • SQL: Loading data into server at real time

    How can I load date into server at real time in SQL?

    latha1705 pointsBadges:
  • Where should I start my entry-level IT career?

    How do I start career in IT industry when I have got bachelor's degree a long time back. I do not have an experience in IT but in HR. I do not have an experience in Canada where I have migrated 9 months back. There are very few females in IT industry. Where should I start. I even thought of...

    rinkyyy35 pointsBadges:
  • SQL stored procedure is taking too much time to execute

    One store procedure is working fine at one location. But the same store procedure is taking too much time to execute in different location on same network. What would be reason for this and how to reduce response time?

    mukeshkumar1230 pointsBadges:
  • How to get data in DB2 based on index like (LIMIT 2,9) in SQL and other databases.

    In other databases we get data based on index using LIMIT. Example: SELECT * FROM ZEMPLOYEE LIMIT 2,9. I tried using native SQL it works fine if we give LIMIT 3, it will fetch the records from 1-3 but when I give LIMIT 2,9. Then it should fetch the data from 2nd record to 9th record but It through...

    arshadshaikh5 pointsBadges:
  • SQL query: Find out the count of employee whose name is more than one time

    In SQL, how do I find out the count of employee whose name is more than one time in a table?

    meghanap5 pointsBadges:
  • SQL: Adding a new column to an existing table

    What are the questions from a BA standpoint? Shall I need to ask the business?

    ashishonweb15 pointsBadges:
  • Get all table names by SQL

    Hi, How can I get all the table names of a bib by a SQL-query? Thank you.

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