by: Philip |
last post by:
Hi all,
Question from a guy who knows PL/SQL, but is starting with
Transac-SQL on SQL Server....
Is it possible to have a sub procedure in a Stored Procedure, like
we do in a PL/sql package ?...
|
by: June Moore |
last post by:
Hi all,
I have a stored procedure that return a resultset
e.g. stored proc: get_employee_details
select emp_id, emp_name, emp_salary, emp_position
from empoloyee
I would like to write...
|
by: jamiemcc |
last post by:
Hi,
I would like to have 1 stored procedure call another stored procedure
(which contains multiple select statements) and then be able to access
the 3 result sets.
Example
Create Procedure ....
|
by: marc |
last post by:
I've been developing a stored procedure that uses a user defined
function in the query portion of the procedure. However, since the end
product needs to allow for dynamic table names, the UDF will...
|
by: George |
last post by:
HI ,
I am getting the below error while i compile a Store procedure which
is my main store procedure and does the call to all other supporting
stored procedure.
Compartively its a large file...
|
by: Alex |
last post by:
Hi...
I have a stored procedure that takes in a large number of parameters (around
30) and returns (as output parameters) another 10 or so.
At the moment, each parameter is declared, defined...
|
by: ILCSP |
last post by:
Hello, I'm trying to accomplish 3 things with one stored procedure.
I'm trying to search for a record in table X, use the outcome of that
search to insert another record in table Y and then exec...
|
by: eRTIS SQL |
last post by:
hi,
I want to use a stored procedure inside a stored procedure simulteanously changing the database.
this is my base store procedure
alter PROCEDURE create_file @dbname sysname
AS
declare...
|
by: svkreddy |
last post by:
Dear All,
Please provide the simple information about stored procedures and stored functions in microsoft sql server2005.
Please give the information about Nested procedures and nested funtions....
|
by: Lin100 |
last post by:
Access ADP and Stored Procedure Did not Return Any Records
Access 2002 and SQL 2000 Server
I have a form named "Selector", and it have four combo boxes and a subform named...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
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...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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
|
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...
|