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

Invoking mysqldump from script without password prompt

I need to execute a cmd command in Visual Basic. It's not difficult but i need to give a argument while the external Programm runs. F:\mysql-5.7.13-winx64\bin\mysqldump.exe -h -u -p > abcd.sql But after that is executed, the…
Dominic Järmann
  • 361
  • 1
  • 7
  • 18
5
votes
3 answers

C: put x86 instructions into array and execute them

Is there any way to put processor instructions into array, make its memory segment executable and run it as a simple function: int main() { char myarr[13] = {0x90, 0xc3}; (void (*)()) myfunc = (void (*)()) myarr; myfunc(); return…
5
votes
1 answer

How to execute a script in zsh and then become interactive?

I want to run a predetermined set of commands after the invocation of zsh (i.e. after .zshrc is executed) that returns the user to an interactive shell when complete. Things like this comes to my mind: urxvt -e 'zsh -c ". scriptname"' but instead…
5
votes
1 answer

Passing arguments to executable not working in C++

This is the source code for "sleeper.exe" I have: int main(int argc, char** argv) { cout<
Koray Tugay
  • 22,894
  • 45
  • 188
  • 319
5
votes
2 answers

Python hangs during a cursor.execute() using Psycopg2

I currently have a problem with my Python script that when I execute a SQL function from cursor.execute() for a specific function, It runs the function, function completes, and then the script hangs for somewhere close to five hours before resuming…
BagoDev
  • 313
  • 6
  • 12
5
votes
2 answers

How to compile and run a C++ program from Eclipse?

I am trying to write, compile and execute a "HelloWorld" C++ program using Eclipse. I have managed to install and run Eclipse, create a new project and write the HelloWorld program. Now I would like to compile it and to run. I did not find "Compile"…
Roman
  • 124,451
  • 167
  • 349
  • 456
4
votes
5 answers

Running multiple C programs from a C program under Linux

I'm trying to learn a bit or 2 about process communication under Linux, so I wrote 2 simple C programs that communicate with each other. However, it's a bit annoying to have to run them manually every single time, so I'd like to know is there a way…
ioreskovic
  • 5,531
  • 5
  • 39
  • 70
4
votes
2 answers

SQLAlchemy Execute with raw SQL containing @DECLARE local tables

I'm stuck -- I have the following python script with SQL alchemy which I've been using quite successfully for several other purposes. import sqlalchemy from sqlalchemy import MetaData from sqlalchemy.orm import * engine =…
user1207980
  • 41
  • 1
  • 2
4
votes
1 answer

c++ how to run an .exe file whose contents are stored in a char array?

I'm making a specific program and i just wondered if I could do this: run a file whose contents are stored in a char array ON WINDOWS. this is the code that reads the executable and stores it in a char array: filetoopen.open (C:\blahlbah.exe,…
user963395
4
votes
4 answers

Can't execute command from crontab?

I want to update some stuff in my database everyday at 16:00. So I use crontab which execute command which run my file.php which run the update. It works perfectly when I execute the command in the bash but There is a problem with the…
user420574
  • 1,437
  • 5
  • 21
  • 33
4
votes
4 answers

Command to execute a script later

I would like to execute a script after 12 hours. I could execute the script by remote access, but problem is I will be travelling by flight and may not have internet access. So I was wondering if there is some command to execute a script after few…
Kay
  • 1,957
  • 2
  • 24
  • 46
4
votes
1 answer

Vim - execute command when changed buffer is beein written

Hello fellow Vim users. I am trying to execute a command when I write a buffer with :w. But the command should only be executed if I changed the content of the buffer. I thought somthing like this maybe: autocmd BufWritePost * if modified | echo…
DasOhmoff San
  • 865
  • 6
  • 19
4
votes
0 answers

Cassandra: execute vs. executeAsync

I do not understand the executeAsync()-method of Session-Interface in package com.datastax.driver.core of Java Cassandra-Driver. Ok you can send your query and proceed with the main code, but to get the result you have the invoke get()-method from…
user3133542
  • 1,695
  • 4
  • 21
  • 42
4
votes
4 answers

How to use at command to set python script execute at specified time

When I try to use cron to execute my python script in a future time, I found there is a command at, AFAIK, the cron is for periodically execute, but what my scenario is only execute for once in specified time. and my question is how to add python…
mlzboy
  • 14,343
  • 23
  • 76
  • 97
4
votes
1 answer

passing argument to a vim "execute"

From within Vim, I want to scan a text line by line, and pass its content to an external shell command. For example, I have a list of names and want to say hello to each name of the list. What I've already managed to do is as follows. Given this…
bistrot
  • 103
  • 10