Recent questions tagged stored

0 votes

289 views

1 answer

stored procedures - Handeling Latency in MySQL Transactions

The Problem I'm trying to figure out how to correctly set up a transaction in a database, and account for ... only have permission to get one. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

411 views

1 answer

stored procedures - Using Mysql to do multiple INSERT on linked tables

I have two tables, one linked to the Primary Key of the other. At the moment I INSERT into table A, get ... on which direction to proceed in. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

398 views

1 answer

stored procedures - Does JPA 2.0 support SQL Server table variables?

I am using JPA 2.0 and SQL Server 2008 and I have determined that JPA doesn't like my stored procedures ... it. Thanks for any suggestions. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

376 views

1 answer

stored procedures - How to store SQL result in a variable and parse the result to identify a possible pattern?

The query below INSERT INTO temp SELECT esd, 'E' FROM test_data_sovlp WHERE esd IS NOT NULL UNION ALL SELECT td, ... How can this be done ? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

349 views

1 answer

stored procedures - How to implement the simplest alien in a REST webservice?

I need a JSON endpoint that return data directally from a stored procedure. Example: @Procedure("complex") String ... to answer-Wiki below. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

512 views

1 answer

stored procedures - Unable to debug .Net Code. Could not attach to process. SQL CLR Remote Debugging

I'm trying to debug a CLR based StoredProcedure in Visual Studio 2012 RTM. I have a Sql Database Project. When ... I forget ? thanks in advance See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

374 views

1 answer

stored procedures - SQL Server SELECT INTO and Blocking With Temp Tables

So, recently a DBA is trying to tell us that we cannot use the syntax of SELECT X, Y, Z INTO ... be SQL Server 2008 (Enterprise editions) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

580 views

1 answer

stored procedures - MySQL save results of EXECUTE in a variable?

How do I save the results of EXECUTE statement to a variable? Something like SET a = (EXECUTE stmtl); See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

stored procedures - MySQL UDF sys_exec() doesn't work

I have a trigger which calls a stored procedure with parameters which calls SET result = sys_exec(cmd);. But it gives ... , NEW.num, NEW.name); See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

506 views

1 answer

stored procedures - PostgreSQL cannot begin/end transactions in PL/pgSQL

I am seeking clarification of how to ensure an atomic transaction in a plpgsql function, and where the ... end $body$ LANGUAGE plpgsql; See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

743 views

1 answer

stored procedures - Returning a DataTable using Entity Framework ExecuteStoreQuery

I am working with a system that has many stored procedures that need to be displayed. Creating entities for ... "); return returnDataTable; } See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

361 views

1 answer

stored procedures - How can I keep tblPurchase and tblProductStock table without drop. (I need keep both table and value permanent without drop)

How to change this stored procedure without drop tblPurchase and tblProductStock. When I run my program with this ... .com/a/65774309/13338320 See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

428 views

1 answer

stored procedures - Oracle SQL Developer: Show REFCURSOR Results in Grid?

As a follow-up to the question "Get resultset from oracle stored procedure", is there a way to show the ... the resizer control doesn't help: See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

452 views

1 answer

stored procedures - Entity framework Code First - configure mapping for SqlQuery

I'm using Entity Framework 5 (with Code First approach) to populate a class of mine from a legacy stored procedure ... ()); } Thank you! See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

343 views

1 answer

stored procedures - PostgreSQL procedural language "C" not found

I am trying to use the PL/R procedural language in a PostgreSQL 9.2 database. I have installed the plr ... not find the C procedural language? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

326 views

1 answer

stored procedures - Does MySQL have time-based triggers?

I would like to execute a procedure periodically, how to do that in MySQL? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

278 views

1 answer

stored procedures - SQL Query to show gaps between multiple date ranges

Im working on a SSRS / SQL project and trying to write a query to get the gaps between dates and I ... availability for each device seperately. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

819 views

1 answer

stored procedures - How do I write an SP in phpMyAdmin (MySQL)?

How do I write a stored procedure in phpMyAdmin? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

318 views

1 answer

stored procedures - SQL Server history table - populate through SP or Trigger?

In my SQL Server backend for my app, I want to create history tables for a bunch of my key tables, which ... which is better? Which is faster? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

498 views

1 answer

stored procedures - passing LIMIT as parameters to MySQL sproc

I'm creating a paging class and need to pass in two parameters to my MySQL stored procedure for the LIMIT ... whole query and EXECUTE it? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

778 views

1 answer

stored procedures - MySQL error #2014 - Commands out of sync; you can't run this command now

I am using MySQL and I am defining a stored procedure like this: delimiter ;; Create procedure sp_test() select * ... and what am I doing wrong? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags