473,327 Members | 2,016 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

How to use Scope_Identity with core java?

1
I am inserting some data in a table
Expand|Select|Wrap|Line Numbers
  1. insert into Project VALUES ('Bugger','active') set @iVariable=SCOPE_IDENTITY()
now i want to use this @ivariable to insert its value in another table using java.
Please tell me how to do this?
Mar 25 '13 #1
1 1904
r035198x
13,262 8TB
What SQL language is this @iVariable in and how are you executing the statement from Java?
Mar 25 '13 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Piotr Galuszkiewicz | last post by:
Hi! I'm looking for 6. edition of "Core Java 2 vol.1 - Fundamentals" (authors: Cay Horstman, Gary Cornell). I want to buy back used book from somebody. BUT(!) I'm looking for new, 6. edition...
1
by: vidhya06 | last post by:
Hi All, Can anyone help me out with this dout. Is it possitible to run a java program without a semicolon.... Thanks in advance, Vidhya
0
by: soupick | last post by:
i have use data source in advance java using xml.i want to know how can i use it in core java?
3
by: sajithamol | last post by:
Why we are calling System.gc() method to garbage collection of unused object, if garbage collection is automatically done in Java by daemon thread in background process with regular interval?
3
by: logicthiru | last post by:
hi i want when we clicked the radiobutton one it is display in textarea. i want in core java it is possible or not.
4
by: jith87 | last post by:
What is meant by Core Java?What is meant by Advanced Java?What is the difference between both? Is Core Java useful to connect a JSP front end and MySQL back end?
27
by: Generic Usenet Account | last post by:
Apologies if someone finds this OT I am looking for an open-source C++ implementation of Java API ---- something that does not require a Java run-time environment. So far the only thing that I...
1
by: okfinegourav | last post by:
what is thread in core java
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.