Stack Overflow
Stack Overflow

Questions tagged [execute]

In many dialects of SQL, the execute statement is used to invoke a stored procedure.

In many dialects of SQL, the execute or exec statement is used to invoke a stored procedure.

For example:

CREATE PROCEDURE MyStoredProc @myParam NVARCHAR(500)
AS
BEGIN
    ...
END
GO

EXEC MyStoredProc @myParam = N'Testing'

Related Topics

1326 questions
7
votes
3 answers

INSERT EXECUTE FORMAT Postgresql string

I want to create a function which will update the table. I am trying to run it: SELECT insert_function('asda', 1 ,1 , 'asd', 1) But I get the error: LINE 3 VALUES("asda","1","1","asd","1") column doesn't exist. When I am trying rot run: SELECT…
user565447
  • 969
  • 3
  • 14
  • 29
7
votes
1 answer

Create an Array with a dynamic Query in PL/pgSQL

I am trying to create an array with a dynamic select query in a plpgsql function. Unfortunately I get an syntax error. ERROR: syntax error at or near "EXECUTE" ZEILE 19: SELECT DISTINCT INTO outputIdsToDelete ARRAY( EXECUTE findA... …
Veselin
  • 197
  • 2
  • 12
6
votes
2 answers

Swift - Execute code on LaunchScreen

In iOS there is an LaunchScreen before you're app is ready. Can you add things to do (Code) to this? I want to execute a JSON request on LaunchScreen but have no idea where to put the code. Thanks In Advance, Kaaseter
Kaaseter
  • 359
  • 1
  • 5
  • 6
6
votes
4 answers

Execute procedure in a trigger

Is it possible to execute a stored procedure inside a trigger? Thank you
user207902
  • 85
  • 1
  • 2
  • 5
6
votes
3 answers

User input to the command line when using Runtime.getRuntime().exec(command);

I dont think this is possible, but I have been using: Process p = Runtime.getRuntime().exec(command); to run commands on the command line, but now I have come accross a situation where the command I am running part way through will ask for some…
ubergam3r
  • 189
  • 1
  • 3
  • 11
6
votes
3 answers

Detect if PDO->execute returns a row/record?

code example; $stmt = $db->prepare('SELECT u.username, u.display_name FROM users u WHERE u.id = :userId'); $stmt->bindValue(':userId', 10); $stmt->execute(); Using prepare -> execute. If your sure the query will return max 1 row; is there a simple…
user1178560
  • 313
  • 1
  • 4
  • 14
6
votes
1 answer

Can you use mysqli prepared statements and transactions together?

All I want to know is if you can use mysqli's prepare, execute, and rollback together? $m = new mysqli($dbhost,$dbuser,$dbpassword,$dbname); $m->autocommit(FALSE); $stmt = $m->prepare("INSERT `table` (`name`,`gender`,`age`) VALUES…
Joseph Pahl
  • 61
  • 2
6
votes
4 answers

How to execute text as PHP

I have a problem, I want to grab text and execute text as PHP, but how do I do this? For example I have this code in a .txt file: $tweetcpitems->post('statuses/update', array('status' => wordFilter("The item Blue has been released on…
S17514
  • 265
  • 2
  • 7
  • 16
5
votes
4 answers

Auto run when USB plugged in

Is it possible to make a program auto run (execute) when the USB it is stored on is plugged into a computer I don't think this is possible due to the searching I have looked at on the Internet and also the security risk such coding would have E.g. I…
Dan1676
  • 1,685
  • 8
  • 24
  • 35
5
votes
1 answer

Datacontext ExecuteCommand parameters in IN statement

What is the best way to run a custom sql statement using IN from a C# LinQ to sql datacontext? I have tried: db.ExecuteCommand( "UPDATE tblCard SET used = 1 WHERE id IN ({0}) AND customer_id = {1}", Request.Form["ids"], customer_id ); Which…
Matthew Hood
  • 958
  • 3
  • 13
  • 22
5
votes
1 answer

aws ecs execute-command failed because was not enabled

I am running aws ecs execute-command --cluster UltimaF --task 838d773b17954bcfbbacf343fb4fea70 --container ultima --interactive --command "/bin/sh" Getting back: An error occurred (InvalidParameterException) when calling the ExecuteCommand…
Anatoly Bugakov
  • 772
  • 1
  • 7
  • 18
5
votes
5 answers

R Code Taking Too Long To Run

I have the following code running and it's taking me a long time to run. How do I know if it's still doing its job or it got stuck somewhere. noise4<-NULL; for(i in 1:length(noise3)) { if(is.na(noise3[i])==TRUE) { next; } else …
Concerned_Citizen
  • 6,548
  • 18
  • 57
  • 75
5
votes
3 answers

Only allowing a function to run n times with wrapper function

I need to make a wrapper function to invoke a function multiply with a given number num of times to allow the multiply to execute. nTimes(num,2) Then assign to runTwice -- runTwice can be any function that invoke the nTimes function which given a…
Ming Huang
  • 1,310
  • 3
  • 16
  • 25
5
votes
2 answers

How to Run the spring boot jar

I have spring boot jar. It contains boot-inf folder with that folder it contains classes and lib folder. I need to run the certain class which is having main method. But I don't know how to run it. For normal jar we can use the below format to run…
ArockiaRaj
  • 588
  • 4
  • 17
5
votes
3 answers

tkinter left clicks on a TAB in your GUI. How to detect when user has done this

I have a GUI written in tkinter and all works fine. I want to enhance it so that when a user left clicks on a certain tab with the mouse, a method is executed. I thought this would be straight forward but I can't get it working. My code is def…
Ab Bennett
  • 1,391
  • 17
  • 24
1 2
3
…
88 89