A subroutine available to applications accessing a relational database system.
0
votes
1answer
15 views
MSSQL trigger will not work with stored procedure
My code is to have a trigger that recognize when a job failed, sends an email and update our ticketing system using a stored procedure that is in a linked db.
The emailing part works perfect, but ...
1
vote
0answers
17 views
Mysql stored proc returning 500 empty rows
I have a table (vendTable) that contains venName and venDesc. Both varchar(30) NOT NULL. Contains 500 rows that get refreshed everyday. The table is truncated and reloaded daily. No indexes.
...
1
vote
2answers
26 views
Displaying results of a Stored Procedure in MVC View (EF 5 / MVC 4)
The goal
I want to display in my view the results of stored procedure.
The problem
Entity Framework automatically imported for me a method that executes a procedure, however I'm not getting the ...
0
votes
0answers
16 views
Execute Store Procedure from Linq to Sql WCF
I have a stored procedure for getting user details. In that there is one input parameter i.e. @UserName. Here is my stored procedure
USE [Test]
GO
/****** Object: StoredProcedure ...
0
votes
1answer
32 views
Mysql stored procedure too slow
I have written a stored procedure in my sql which is very slow. there are million records in database .
DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `FetchEnergyLine`(IN From_Time INT, ...
0
votes
1answer
22 views
Entity Framework stored procedure result
I can have stored procedure return a collection of existing entities. How do I join/include other entities in this scenario? Is this even possible?
0
votes
2answers
19 views
Getting String Value From Database in C#
I have a database table in which i am saving created users along with username now what i want to get string value from my database if username exists in database and then i will show error message ...
1
vote
4answers
36 views
Subqueries are not allowed in this context. Only scalar expressions are allowed
My stored procedure is working fine in SQL Server 2008 but when i try to run the same procedure in SQL server 2005 it throws this error stating
Subqueries are not allowed in this context. Only ...
0
votes
0answers
36 views
java.sql.SQLException: Incorrect syntax near the keyword 'top'
I have stored procedure
CREATE PROC dbo.TestSproc
as
select COUNT(*) from dbo.TestCase
It doesn't make any useful things but I cannot invoke it via hibernate
Query query = ...
1
vote
3answers
1k views
simple insert procedure, check for duplicate
i am creating a program that is going to insert data into a table which is pretty simple
but my issue is i want my insert statement to make sure that it isnt inserting duplicate data
i want to ...
0
votes
2answers
35 views
Passing result of procedure from Entity Framework to view
The goal
I'm using Entity Framework with C# + ASP.NET MVC 4 and I have a stored procedure in my database (MySQL). I want to display the result of this procedure on my view.
The problem: I don't know ...
0
votes
1answer
43 views
php and sql server stored procedure executing
please help me.
i have a stored procedure that do a login proccess and in different conditions return different value in same structure
this is my code
create PROCEDURE [dbo].[I_SPCheckUserLogin]
...
0
votes
1answer
9 views
How to store Multiple value in a variable in Sql Server
I have the following TSQL Statement:
declare @id1 int
set @id1 = (select o.OrderId from [Order] o where o.M_Order_Id=@id)
set @Message = select om.Modifier_Id
from [Order] o ...
0
votes
1answer
16 views
How to define call of stored procedure in hibernate mapping file and then call it from java (mssql server)
I need to call stored procedure in java code (entityManager is available only). This stored procedure should be defined in some hbm.xml file.
I didn't find any solution how to do it.
In hibernate ...
-2
votes
0answers
19 views
How to create query or store procedure on MS Sql to expand column from row
Need help from you all in writing up this query. Running SQL 2008.
Field 1
========
Hello
Man
Lady
I need to result :
F1 F2 F3
=================================
Hello ...
