|
by: Amit D.Shinde |
last post by:
Hi Experts,
i am writting a stored procedure in sql server 7. Its a simple stored
procedure
It is my first stored procedure.
I want insert a record in table if the primary key field user id
already does not exists. if it exists SP should pass 0 as output else
if insert is successfull it should pass 1 to calling sp.
But following SP raising...
|
by: Mike |
last post by:
Hello,
I have a few rather urgent questions that I hope someone can help with (I
need to figure this out prior to a meeting tomorrow.) First, a bit of
background: The company I work for is developing a web-based application,
one part of which involves allowing the user the ability to page through
transaction "history" information.
The...
|
by: Martin Feuersteiner |
last post by:
Dear Group
I'm having a very weird problem. Any hints are greatly appreciated.
I'm returning two values from a MS SQL Server 2000 stored procedure to my
Webapplication and store them in sessions.
Like This:
prm4 = cmd1.CreateParameter
With prm4
|
by: razaqtelecom |
last post by:
Hi,
I want to know how can i write a stored procedure for the following sceario.
Take if there are three tables, table1, table2, table3 and table1 is linked with table2 and table 2 is linked with table3.
Now i have to compare a data in table 3 for one of the rows in table1 where as For the same row in table1 there will 100 rows in table 2...
|
by: situ |
last post by:
hi all,
this is the procedure i have created
CREATE PROCEDURE XIREL2.proc_size_2 (p_dummy CHAR(1))
SPECIFIC XIREL2.proc_size_2
DYNAMIC RESULT SETS 3
------------------------------------------------------------------------
-- SQL Stored Procedure
|
|
by: Roger |
last post by:
have a stored procedure running on DB2 V7 Z/os calling a COBOL
program to do some inserts. The stored procedure have 3 input columns
and one column is of varchar(32648)
The stored procedure is being called from a V7 DB2 connect client.
The stored procedure is giving SQL0104N An unexpected token was found
if my varchar data goes beyond...
|
by: shsandeep |
last post by:
I 'recreated' a stored procedure.
Earlier, i had given privileges to a particular group but now (after
rebuilding) when I try to grant execute privilege for the SP to the same
user group, it gives me the below message.
Any clues on this??
SQL0458N In a reference to routine
"SITSCHM.SP_ERND_PREM" by signature, a matching routine could...
|
by: sri |
last post by:
My environment is DB2v9.1, Windows/AIX and I am trying to compile the
stored proc below and I am getting an error, "ERROR SQL0104N An unexpected token "WITH" was found following "User_ID
= UsrID; ". Expected tokens may include: "SELECT". LINE
NUMBER=11. SQLSTATE=42601"
CREATE PROCEDURE TestProc(IN UsrID INT)
LANGUAGE SQL...
|
by: mohit1286 |
last post by:
my stored procedure in db2 is--->
create procedure temp_bill(in UPC_cd character(6))
language sql
begin
declare prod_cd character(8);declare prod_desc varchar(30);declare discount decimal(2,2);declare
prod_sp decimal(7,2);declare
counts int;declare deal_check char(6);select
deal_id into deal_check from db2admin.product where...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|