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
-2
votes
1 answer

bash permission set to 777 but file execution still denied

I wrote a bash script and am trying to execute it from sh but I am getting a "permission denied error". I set to permissions to 777 but it is still preventing me from executing the file. # which sh /bin/sh # ls -l myscript.sh -rwxrwxrwx 1 root …
stevo
  • 171
  • 5
  • 16
-2
votes
2 answers

Batch Program executes on a certian date?

I've been trying to get a batch to start another batch on a certain date. (specified) I've tried all that I can think of. TIMEOUT does not work for this. Any suggestions? EDIT: I am sorry I didn't include enough information. by "batch" I meant to…
MabeeDev
  • 15
  • 1
  • 7
-2
votes
2 answers

Error While Executing sp_executesql

exec sp_executesql N'SELECT (STUFF (( SELECT '',''+ NAME from Project WHERE ProjectTypeID=1 and OutputHierarchyID IN (SELECT DISTINCT HierarchyID from HierarchyNode'+ @TextVal +'''' + N')FOR XML PATH('''')), 1, 1, ''''))AS INDUSTRIES', …
rajabaksh
  • 1
  • 1
-3
votes
1 answer

Why is the foo() function executed while not having been called?

I'm kind of new to PHP so please excuse the simplicity of my question in case it was, I have a function foo() that always returns true, now my question is that while I have only checked the true being of foo() and not called the foo() function…
christy
  • 3
  • 5
-3
votes
1 answer

how to execute python terminal from vs code to cmd or other

I learn about python, so I run python code in visual studio code on windows by creating a folder consisting of files main.py and settings.json. The results in the terminal have no errors, but I am confused about execute the results to cmd or other…
fefe
  • 7
  • 1
-3
votes
1 answer

How to execute a stored procedure in Oracle

I have written a stored procedure and i want to execute it. The procedure is as follows: create or replace procedure details( p_cursor OUT SYS_REFCURSOR) is begin OPEN p_cursor FOR select name,address,phone,email from client …
Talha Jaleel Chatha
  • 1
  • 1
  • 3
-3
votes
3 answers

How to execute a statement which was a string initially

My question is about how to make the compiler treats my string as an executable statement, consider my string mystr='1+2+3', now the question is what's the code to put in function func so when I execute the following command func(mystr) I get 6 on…
Mehdi
  • 41
  • 9
-3
votes
2 answers

return json to activity by asynctask

I'm using a doInBackground method to get a json from a web service so I can use it in my main activity here's what I did but it doesn't work public class JSONTransmitter extends AsyncTask { @Override protected…
Amine Al
  • 77
  • 2
  • 11
-3
votes
2 answers

Cron job, execute php script

I want to run a php script every morning, the script would send an email. But the email I get from cron always contains an error message. Can somebody please help?
Arnold
  • 17
  • 1
  • 3
-3
votes
1 answer

Table as parameter in SQL Server

I have the following stored procedure: ALTER procedure [dbo].[jk_insertAllLocation] @locationTbl as locationTable readonly, @TableName varchar(100) as declare @tbl as locationTable, @sql nvarchar(max) begin set @sql =…
User7291
  • 1,095
  • 3
  • 29
  • 71
-3
votes
2 answers

Getting a script to generate 300 sets of random characters

I would like to know how I can get the script below to generate 300 sets of random characters. This would avoid my having to press the reload button, 300 times. Here is my script:
Funk Forty Niner
  • 74,450
  • 15
  • 68
  • 141
-3
votes
1 answer

Making a Git Bash "Shell" Script to execute already existing commands

i would like to make a "script" to perform some commands for me in git bash. i would then start git bash and type git myScriptName and hit enter, the it would perform: cd myProjectFolderName (ENTER) git init (ENTER) git add -A (ENTER) …
user1344948
  • 141
  • 1
  • 3
  • 11
-4
votes
1 answer

Need help to develop CHEF recipe to execute 4 bash scripts on 4 servers in sequence and verify if each script executed successfully

I need help to develop CHEF recipe to automate application installation. Here is my requirement - Well, I have 4 different bash scripts and need to execute on 4 different severs in sequence like script 'A' to execute on server '1' and verify that…
Rohith G
  • 1
-4
votes
3 answers

what does the following code means?

I met this question in a interview occassion, the man asked me what is the result if i compile and execute the following code, and why. I am curious about this question and i did not really got it. When i typing gcc f1.c f2.c and then ./a.out, it…
true2009fans
  • 23
  • 5
-4
votes
2 answers

How to Loop a sql Query in C#

I wanna execute a Query for 10 times to get random values, but my code never stops, it keeps looping and gives no response. This is my code int j = 0; do { DataSet AVATARLINE = new DataSet(); SqlDataAdapter AVATARLINE_1 = new…
user2010164
  • 47
  • 1
  • 5
1 2 3
…
88
89