INSERT Statement

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

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.

How to retrieve, add and update data from SQL Server 2005 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...

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

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

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

Hi Experts, I am gettting this error when i run my test case for my PL/SQL procedure ,which hav select and Insert statement only ,not clear where i wud hav went wrong,please guide me where should i check exactly its poping this error message which i catched in exception piece after Insert statement

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

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

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?

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

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

SQL insert statement

Hopefully there are some ASP experts put there who can help me. I am trying to write an SQL insert statement to populate an access database from an HTML form. When I submit the form, I am getting page cannot be displayed with the following error message: Error Type: Microsoft VBScript compilation...

inserting

from front end we will get 20 records at a time.how can we insert them into a table .

Insert for a table

I have a table which consists of lakhs of records and itemnumber is one of the column.I want to insert those records into the same table but with different new itemnumber from another table.what is the best way of doing it?

Syntax to reference a table on a database residing on another server

I have the following insert statement: insert into Resident(Identifier_Type,Identifier,Full_Name,Dob,DL_Number,DL_State,Change_User,Change_Date,Change_PropID) select N'SS',Social,Full_Name,DOB,DL_Number,N'TX',Change_User,Change_Date,Change_PropID from N'haa-sql1.imisTest.dbo.Resident' I'm getting...

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