stored-procedures Questions
3
Solved
.NET Core 3.1 supports DataTable/DataSet, DataRow, DataView, etc - which was not available when the OP created the following question
based on my research, it seems like .net core does not suppor...
Egeria asked 18/2, 2017 at 9:6
3
Solved
my stored procedure in MySQL fails with Mysql::Error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='.
The procedure fails when in SELECT clau...
Chalcopyrite asked 7/12, 2010 at 11:6
14
Solved
I need to execute a stored procedure after my form submits data. I have the stored procedure working like I want it, and I have my form working properly. I just do not know the statement to execute...
Exhaustion asked 28/12, 2015 at 16:27
6
I am using codeigniter that has mysqli as db driver, am trying to call a simple stored procedure from my model but get an error. What am i doing wrong
Error Number: 1064
You have an error in your...
Grigg asked 18/8, 2015 at 8:24
5
I have several stored procedures in my database, structured like this:
CREATE PROCEDURE MyProcedure (.....)
AS
DECLARE @myvar NVARCHAR(100);
SET @myvar = (SELECT .... FROM my_table WHERE ....)
G...
Viscountess asked 10/3, 2015 at 10:1
10
Solved
SELECT col1,
col2,
col3,
EXEC GetAIntFromStoredProc(T.col1) AS col4
FROM Tbl AS T
WHERE (col2 = @parm)
How to write this SQL query in SQL Server 2008?
Pluralism asked 24/1, 2013 at 17:10
3
Solved
I want to add Isolation level in my procedure and for that I wanted to confirm that which one is the correct format from below:
Attempt #1 - setting isolation level before calling the stored proce...
Illgotten asked 21/2, 2017 at 6:31
5
Solved
I am having SQL server 2008 and i am having 10 different databases in it and now i want to search one stored procedure that in which database the stored procedure is present.
Mentioned as duplicat...
Furthermore asked 23/3, 2015 at 9:47
6
Solved
I have a SELECT request with 'inner join' in the joined table is a column with bit type.
I want to select 1 if in the joined table is at most one value with 1. If it is not the case the value will...
Outface asked 29/5, 2012 at 17:34
2
Solved
Right. So I've created a stored procedure in a MySQL DB which happens to use SUBSTRING.
Running the procedure via a query gives me:
SQL Error 1630: Function mydatabase.SUBSTRING does not exist
...
Berylberyle asked 17/8, 2010 at 22:4
3
Solved
From PHP I would like to call a stored procedure in MySQL. The procedure takes input and output parameters -- not "INOUT" parameters.
For a simple example, say I have the following stored procedur...
Aggy asked 9/6, 2013 at 21:51
6
I want to execute one query in Stored Procedure, that should loop all the array values.
For example:
declare arrayStoreID={1001,2400,2001,5000}
for(int i=0;i<arrayStoreID.length;i++)
{
sele...
Surmount asked 16/1, 2017 at 8:7
3
Solved
What is the basic difference between SQL Server stored procedures (sp_) and extended stored procedures (xp_)? Why there are extended procedures anyway?
Danu asked 16/6, 2010 at 18:11
7
Solved
In my DB I have two tables Items(Id, ..., ToatlViews int) and ItemViews (id, ItemId, Timestamp)
In ItemViews table I store all views of an item as they come to the site. From time to time I want t...
Cardiff asked 22/5, 2012 at 11:47
3
Solved
I have a table that look something like this
value_1 value_2 value_3
---------------------------
1 2 3
4 5 6
7 8 9
... ... ...
and I need to run a stored procedure for every row of this tabl...
Leisure asked 11/6, 2014 at 7:27
7
Hello im having a hard time with this stored procedure. I'm getting the error:
Result consisted of more than one row.
Here is my stored procedure:
DELIMITER $$
DROP PROCEDURE IF EXISTS `dss`.`COST...
Nickel asked 11/2, 2010 at 6:32
4
Solved
I need to return through Web Api a Base64 XML output based upon calling a stored procedures which runs 5 different queries.
Stored procedure is not written ( I need to write it ) but there are 5 q...
Anticathode asked 13/10, 2016 at 6:27
15
Solved
I'm working on an application where one can get information on movies from a database as well as add, update and delete the movies. In the database I have three tables (Movie, Genre and MovieGenre ...
Dour asked 15/3, 2012 at 12:28
6
Solved
I am developing a framework, where in I am a calling stored procedure with dynamically created parameters. I am building parameter collection at the runtime.
The problem occurs when I am passing ...
Zsolway asked 3/3, 2013 at 22:10
12
There are lot of tables and sp in the db. I find the tables name which are used in the specific sp (stored procedure).
sp_depends %sp_name% not give the desire result. I am also used INFORMATION_SC...
Tennietenniel asked 26/4, 2013 at 5:43
6
Solved
Let's say I have a stored procedure which returns a large set of data. Can I write another query to filter the result of stored procedure?
For example:
select * from
EXEC xp_readerrorlog
where L...
Policy asked 21/2, 2012 at 13:35
6
Solved
I am pretty new to SQL and hope someone here can help me with this.
I have a stored procedure where I would like to pass a different value depending on whether a column contains a certain country...
Dethrone asked 7/5, 2014 at 9:26
2
I have a query that I am putting in to a stored procedure. When I run the query with local variables the query takes ~1 second to run. When I put the same query inside of a stored procedure and cal...
Feinberg asked 16/12, 2015 at 20:18
3
Solved
I would like to do the following. Basically have a stored procedure call another stored procedure that returns a table. How is this done?
ALTER PROC [GETSomeStuff]
AS
BEGIN
@table = EXEC CB_G...
Bela asked 2/2, 2009 at 19:0
3
Solved
Can anyone share me a light on how to create a subroutine in a stored procedure in SQL Server?
I have a procedures in Oracle that will call a subroutine within the same procedures for 50 times in ...
Theatre asked 10/4, 2020 at 6:40
1 Next >
© 2022 - 2024 — McMap. All rights reserved.