• Can I select the identity value from an insert statement?

    Our company is using iSeries for DB2/AS400 and we're hoping someone can help us with this simple question. Would there be a way to return the identity value from an insert statement without using two lines of SQL? We're currently being forced to use inline SQL in C# to perform an insert. Basically,...

    ITKE342,195 pointsBadges:
  • Inserting multiple rows in Oracle 10g

    I need to insert multiple rows of data into multiple tables from one temporary table. I need to put some of the columns into one, some into another, and the remainder into another table. I realize I will need to create INSERT statements for each table insert. Is there an easy way to select specific...

    Ora mer20 pointsBadges:
  • SQL Server 2012 Express has slowed down dramatically

    I just recently moved my .NET Development over from a Core2Duo to a new Core i7-3820 machine. No changes were made to the project code and both run on SQL Server 2012 Express.For the past week, I've seen a dramatic slowdown with INSERT INTO commands. Can someone tell me why this is happening?...

    ITKE342,195 pointsBadges:
  • How to retrieve, add and update data manually using VB.NET 2005

    Hey guys! I'm quite new to VB.NET 2005. I need to know how to add, update and retrieve data manually using VB.NET 2005. In the software which I'm trying to implement, data is entered in text boxes and then they are updated/added into an SQL table. When retrieving the data, for example: A student is...

    Obhasha0795 pointsBadges:
  • I am getting ORA-01422: Exact fetch returns more than requested number of rows

    Hi experts, I am getting this error when I run my test case for my PL/SQL procedure, which has select and insert statements only. Not clear where I would have went wrong, Please guide me where should I check exactly. Its popping up with this error message which i caught in a exception piece after...

    Inprise610 pointsBadges:
  • Cannot INSERT data into table with identity column

    In my program I have an EmployeeRegistry table which holds data of each employee's work attendance. Every attendance record is uniquely distinguished by an IDENTITY COLUMN called "AttendanceID" which has an IDENTITY SEED of 1 and an IDENTITY increment of 1. However when I try to insert an...

    Obhasha0795 pointsBadges:
  • PL/SQL: How to use EXCEPTION statement before INSERT?

    Hi Experts how to use EXCEPTION statement before INSERT stm in PL/SQL Block Please help me with syntax or format is this option possilbe as well?

    Inprise610 pointsBadges:
  • Recovering lost data from SQL Server 2005

    Running SQL Server 2005. I found that I had lost about 2000 records the Assets table and more records in the associated tables Timeassets and AssetBillingrates.  Each of the tables uses an Id field as the Primary Key. I was able to identify the key records that had been lost and tried inserting...

    BClawson10 pointsBadges:
  • Updating a SQL Server record in a large table

    We are using SQL Server 2005 and I have an SQL DB on it with 270,876 records in it. There is a PRIMARY KEY defined on the first field called RecordID (Identity field). The index name is PK_ListOfFiles_as_of_3-7-2011. If I execute the following command from the Query Window on the server it takes a...

    BDW65 pointsBadges:
  • Select/Insert Statements causing out of memory error run under VB Script

    I'm using VB Script on a Windows 2003 Server against an Oracle 10g database to both query against a table and insert new rows of data against that same table but as it runs it starts eating up RAM and when it gets to about 1.5gb it causes the out of memory error.  As far as the Select...

    TheBandit15 pointsBadges:
  • Exceeding maximum record locks in Access

    i have written code to import information from several text files into a linked table. It works fine for a while, but eventually I always get an error about exceeding the maximum allowed locks. I do not want to change the registry - i would rather just not have any locks (because I don't need them).

    Rampagingpigeon25 pointsBadges:
  • Change the size of a column and then reorganize the rows in SQL tables

    I think this one will be tricky. What I have is a table like: CREATE TABLE PHOTO_DETAIL   (     "PHOTO"        VARCHAR2(25 BYTE) NOT NULL ENABLE,     "NUM_LINE"   NUMBER(20,0) NOT NULL ENABLE,     "PHOTO_LINE"  VARCHAR2(180 BYTE)   )   what I am going to have is: CREATE TABLE...

    Hispi25 pointsBadges:
  • Capitalize First Character

    How can ensure that when certain columns in a row are INSERTed/UPDATEd, the first letter of the value is capitalized and the rest are lower case? For example "QUESTION" or "question" should be converted to "Question".

    VelameLaCosa110 pointsBadges:
  • jsp–param and sql:update

    Hello, Could anyone tell me if I need to do something special to use a param value as an sql insert statement in <sql:update>? The param value displays fine if I use <c:out>, but the value doesn't get inserted in a table by an insert statement.

    Eoeo5 pointsBadges:
  • PL/SQL

    Hi Experts, I would like to mentione here i was trying to test one package and found the package has a procedure named SET() which hav UPDATE on Report table and INSERT on A_R table in same transaction Both the above mentioned tables hav a tim_upt column which s given as systimestamp and strange it...

    Inprise610 pointsBadges:
  • PL/SQL Insert

    Hi Experts, I am trying to do 2 INSERT stms on 2 tables consecutively n same transaction and my first insert is successful while doing the insert on second table which is completely carry same set of attibutes and values of 1st table + 1 additional static value attribute,it gives ORA :01400 error...

    Inprise610 pointsBadges:
  • PL/SQL: How to handle OUT Parameter during INSERT

    HI Experts, I have a OUT parameter in my procedure(whihc performs INSERT data into a table),how to handle this OUT parameter (primary key of table) -- Will Insert statement inside the PL/SQL block should include this parameter or we should use SELECT stm after Insert to add this attribute ,i am...

    Inprise610 pointsBadges:
  • Inserting rows and multiple rows in SQL Server 2005 Express

    Anyone there who can help me solve my problem? I can’t continue my program because of this problem which I know someone can solve or can suggest the best possible solution. I have a project in my study doing simple accounting program. To facilitate the discussion, I will just show you the three...

    Ariell5 pointsBadges:
  • where does the file get created in AS/400 system when we fire embedded INSERT query in an RPGLE program

    we are inserting deptid in departments table using the following INSERT statement: INSERT INTO departments (department_id, department_name ) VALUES (30, ':Purchasing'); so where does the departments file get created in As/400 system? when we are doing a runqry on departments file, it is giving the...

    Mohan K695 pointsBadges:
  • PERFORMANCE ISSUE while inserting bulk data in a blank table from 2 different tables

    how to improve insert performance in insert into mis_fcr_all_txns_susp_temp (select * from mis_fcr_all_txns_combi a where exists (select acct_no from mis_fcr_all_txns_fraud3 b where a.acct_no = b.acct_no) and a.TXN_DATE BETWEEN (REPORT_DATE - 60) AND (REPORT_DATE - 30));

    031219805 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