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

How do I execute classes in Puppet

I just started using puppet. I don't know how to execute classes in puppet. I've my files "config.pp init.pp install.pp service.pp". For example install.pp : class sshd::install{ ... } Next, i declare my class in init.pp with "include…
NPTK
  • 31
  • 1
  • 3
3
votes
1 answer

Best way to execute tests on Jenkins using large files

I have a very large tar file(>1GB) that needs to be checked out and is a precondition for executing any tests. I cannot have dedicated build server for my tests since tests are going to be executed on slave machines which are disposable. Checking…
Mentor S
  • 41
  • 1
3
votes
2 answers

Postgres- SQL state: 22004 - query string argument of EXECUTE is null

I have a table (named VGI_table) that contains a column (named match_tabl) which contains the names of other tables in the same database along with object_ids for those tables. I am trying to create a plpgsql function that loops through each row in…
MajuS
  • 33
  • 1
  • 2
  • 6
3
votes
2 answers

pandas.io.sql.execute is not autocommiting

I'm trying to delete some rows before inserting new data in my table (the past 30 days have to be updated daily to get accurate numbers). I'm executing this: from datetime import date, datetime, timedelta import pandas as pd from sqlalchemy…
mpopa
  • 31
  • 1
  • 2
3
votes
2 answers

Execute CRON 2 and 3 times per month?

I have following issue. I need to run same script (with different args) in different 5 different dates. 1x per month 2x per month 3x per month 4x per month every day My current code: 1x month (run every month 1st day, 9:00) 0 9 1 * * php…
Kristaps J.
  • 325
  • 3
  • 10
3
votes
2 answers

Hyper Link That Opens .OFT in Outlook

I have some Outlook .oft template files uploaded to a web server. Is it possible to create a link to the individual files that will result in them opening in outlook? I have thus far only managed to create straight up HTML links that simply…
Da Sped
  • 31
  • 1
  • 3
3
votes
1 answer

Execute VBA from Excel 2010 Ribbon

I have been trying different examples of how to move my VBA buttons into the ribbon but either I the text is flagging red(aka error) or examples relate to doing some xml conversions (never done before so they make no sense). All I want to do is move…
narue1992
  • 1,143
  • 1
  • 14
  • 40
3
votes
2 answers

how to open terminal with firefox?

I have an executable file with .sh extension. I want to open this file through firefox with Terminal but it return an error: "filename.sh" can't be opened because Firefox is not allowed to open documents in Terminal. now, how can I change the…
Snowleaf
  • 67
  • 1
  • 3
  • 8
3
votes
4 answers

FFmpeg android execute

On windows I could cut a video with below code with ffmpeg.exe Can't use ffmpeg in android. I used gradle to grab ffmpeg in my app. dependencies { compile fileTree(dir: 'libs', include: ['*.jar']) compile…
Eftekhari
  • 1,001
  • 1
  • 19
  • 37
3
votes
1 answer

No viable alternative at input 'mytable1' cassanda cql python session.execute error

I'm trying to execute a simple cql query in python and I keep getting an error. table1 = "mytable1" table2 = "mytable2" query1 = "SELECT * FROM %s" table1Rows = session.execute(query1, (table1,)) table2Rows = session.execute(query1, (table2,)) The…
user2821523
  • 75
  • 4
3
votes
5 answers

how to get true or false using execute() in Java Statement

I have Statement object called stmt, Connection object conn. stmt = conn.createStatement(); boolean b = stmt.execute("INSERT INTO employee VALUES('E001', 'Smith')") But this always produce false. I want true if above query executed successfully and…
Shavindra Manathunga
  • 79
  • 1
  • 2
  • 7
3
votes
2 answers

How to run PowerShell script using System.Diagnostics.Process.Start in c#?

I'm writing this: using System.Diagnostics; Process.Start("C:\\CodeProjects\\C#\\WindowsPowerShell\\v1.0\\powershell_ise.exe", "-File .\\mp4_to_flac.ps1"); All this does is open up the script in Windows PowerShell ISE. But I also want it to RUN! So…
Awesome_girl
  • 484
  • 3
  • 9
  • 30
3
votes
2 answers

Execute python script with a variable from linux shell

This might be an easy question but I don't know the name of what I'm trying to do, so I don't know how to search for it. Basically when I'm in terminal (linux command line) and I type $ python do_something.py stuff I want to get the stuff to mean…
Grant Brown
  • 613
  • 1
  • 8
  • 11
3
votes
1 answer

PDO::exec or PDO::execute?

I use PDO to connect to my database and I don't know which method is better than the other one for UPDATE, DELETE and INSERT, PDO::exec or PDO::excute. Which should I use?
Ramin
  • 473
  • 1
  • 5
  • 15
3
votes
4 answers

if conditions execute order in C++

I have a if block as below in C++: if( node != NULL && node->next !=NULL ){ //do some stuff } Can anybody tell me do I need to split node and node->next in two if block? or is it guaranteed that node!=NULL will executed before node->next!=NULL…
Jaden
  • 45
  • 7
1 2 3
…
88 89