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

votes

1 answer

SQL Developer Oracle, how to call procedure?

I have delcared function like this: CREATE or replace PROCEDURE proc ( P_ID IN INTEGER, NAME OUT CHAR, SURNAME OUT CHAR, TOTAL OUT CHAR ) AS BEGIN SELECT NAME, SURNAME, sum(TOTAL) AS TOT INTO NAME,SURNAME,TOTAL …

oracle plsql oracle-sqldeveloper execute

asked Nov 25 '15 at 10:53

dreamPr

votes

5 answers

Optimise the solution to Project Euler 12 (Python)

I have the following code for Project Euler Problem 12. However, it takes a very long time to execute. Does anyone have any suggestions for speeding it up? n = input("Enter number: ") def genfact(n): t = [] for i in xrange(1, n+1): …

python time long-integer execute

asked Jul 19 '13 at 10:26

TopGun

votes

4 answers

how to execute task in phing given double and single quotes

This is my command I wish to execute. php -r "apc_clear_cache(); apc_clear_cache('user'); apc_clear_cache('opcode');" This is my attempt in phing

php execute phing

asked Jan 10 '13 at 08:43

Kim Stacks

10,202
35
151
282

votes

5 answers

How to execute bash from within a python file?

I am wondering if it is possible to execute bash code from within a python file. I don't mean run a completely different bash file. I am looking for a method to easily execute bash code that is one line or longer in length. Specifically, I want to…

python bash execute

asked Jan 05 '13 at 17:44

null

votes

4 answers

Execute Perl in Emacs, most basic

I'm learning how to use Perl in Emacs. I used to run R with R-Studio. How do I execute a command without leaving Emacs? Example: In R-studio I type print("hello world") and press Ctrl+Enter and R-studio executes the command and prints "hello…

perl emacs execute

asked Nov 29 '12 at 18:04

Federico C

votes

3 answers

Executing JS Functions at the exact same time

I'm trying to execute two different functions at the exact same time. I have a row of images, and one after the other they light up by changing their opacity, to make it look like they're blinking. Problem is that the timing needs to be exact, and…

javascript function time execute

asked Nov 25 '12 at 22:07

Sera

votes

4 answers

Checking iframe is called from the approved domain?

Possible Duplicate: How to limit display of iframe from an external site to specific domains only What i want is simple. I want to prevent my website to be called from domains I did not approve. Let's say only a.com and b.com can have a page with…

html iframe execute

asked May 18 '12 at 15:39

RWC

4,697
2
22
29

votes

2 answers

Duration time to execute in PHP

I need to program something in PHP but i have to know execution time between my line 5 and my line 14. The problem is that i don't find anything to do what i want (calculate execution time between that lines). How can i synchronize it with another…

php execute

asked May 03 '12 at 23:41

albumex

votes

2 answers

Run a script on a computer from php

I'm unsuccessfully trying to execute a shell command from php. The goal is to switch on/off my music player of my computer/server via internet (with my phone for example). Here is what I would be able to do : I have a very simple file "play.sh"…

php execute lampp

asked Jan 29 '12 at 21:45

Paulair

votes

1 answer

HTML 5 - download and run/execute a file

Does HTML 5 provide a way to run or execute a downloaded file? I've read about the File API to download files but haven't seen mention of how to execute it. It's probably frowned upon due to security concerns, but sometimes there's good reason to…

html file download execute

asked Dec 27 '11 at 23:45

pmont

2,083
22
43

votes

3 answers

execve() failing to launch program in C

I am trying to spawn a new process using execve() from unistd.h on Linux. I have tried passing it the following parameters execve("/bin/ls", "/bin/ls", NULL); but get no result. I do not get an error either, the program just exits. Is there a reason…

c linux assembly execute execve

asked Dec 12 '11 at 04:06

user99545

1,173
3
16
32

votes

2 answers

How to auto-launch a jar file?

I have a game on a USB drive called MyGame.jar. It is an executable jar file. I want to be able to put it on cd's and USB drives. I want the game to start up automatically when the cd or USB is put into the computer, how can i do this? The game…

java jar executable-jar execute

asked Oct 06 '11 at 01:29

gsfd

1,070
2
12
17

votes

1 answer

exec in stored procedure will get the benefits of stored procedure

if i put something DECLARE @Query VARCHAR(8000) SET @Query = 'select * from subscriber where sbs_userid = ' + cast(@UserID as varchar) + ' and SBS_Status in (select statusFlag from #tmpStatusFlag) and…

sql sql-server-2005 stored-procedures execute

asked Oct 04 '11 at 06:54

rahularyansharma

11,156
18
79
135

votes

1 answer

VBScript Execute Method Does Not Declare Variables

I was looking into dynamic "includes" methods and came down to a solution which uses VBScript's Execute function. This works perfectly for me but I noticed that Execute executes the code but this code cannot declare anything like a variable or…

vbscript asp-classic execute

asked Aug 19 '11 at 14:29

Vad

3,658
8
46
81

votes

1 answer

MySQL How to get results after PREPARE and EXECUTE in Stored Procedure?

My current code is : DELIMITER \\ CREATE PROCEDURE sample (IN _car VARCHAR(15)) BEGIN DECLARE _a INTEGER; SET @s = CONCAT('SELECT COUNT(*) FROM train WHERE ', _car, '<=0;'); PREPARE stmt1 FROM @s; EXECUTE stmt1; …

mysql variables variable-assignment execute procedures

asked Aug 08 '11 at 19:03

lostsheep

Prev 1 2 3

…

88 89 Next