I'm just curious if someone can give me some info about sp_execute and what it's used for.
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21073096.html
Zones:
MS SQL ServerDate Answered: 08/09/2004 Rating: 9.4 Views: 199
I want to grant execute permission to all SPs in a database for a user programmatically. for the same i have written batch file with Cursor and trying to substitute SP name in grant command, which ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21128552.html
Zones:
MS SQL ServerDate Answered: 09/13/2004 Rating: 9.4 Views: 0
Hi All,
When I execute stored procedure in pl/sql i give the following command
exec pkg1.prc1(param1,param2,param3,param4);
But I am having problems executing procedure with following defi...
http://www.experts-exchange.com/Database/Oracle/Q_21633609.html
Zones:
OracleDate Answered: 11/17/2005 Rating: 8.8 Views: 0
I have a sp that generates 4 outputs: month1, amt1,month2,amt3 in data access file(c.s).
I would like to execute this SP , and assign these output to varialbes( month1,month2, amt1,amt2) in the...
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_21862642.html
I have a stored procedure(sp) name A_SP. when I execute this sp, many sqls are executed. I want to know whether it is possible to have a list of all the executed sqls from A_SP?. do we have any to...
http://www.experts-exchange.com/Database/Oracle/Q_20436280.html
Zones:
OracleDate Answered: 11/22/2003 Rating: 7.0 Views: 0
try to dynamically get variable NAMES from a table (not the values of the variables, but rather their names), and execute a program with the variables e.g. exec my_sp with a parameter from a table...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20783250.html
Zones:
MS SQL ServerDate Answered: 11/01/2003 Rating: 6.8 Views: 0
Hi all,
I find this to be one of the most confusing things to accomplish in T-SQL. I have a SQL statement that I need to build dynamically, and can't figure out the quotes
SET @strSQL = @...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21251163.html
Zones:
MS SQL ServerDate Answered: 12/22/2004 Rating: 8.2 Views: 4
Hi,
When running profiler I receive hundreds of the following:
exec sp_execute 1, 117, 11xxx
Can someone please explain what causes this and/or how I go about working out the cause?
Joe
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21589868.html
Zones:
MS SQL ServerDate Answered: 10/11/2005 Rating: 8.2 Views: 18
Ive been reading for to long!! Need the solution ASAP (well maybe not ASAP but right away or as soon as possible,, Im so funny!)
Whats the best way to convert this select onto an SP
I'll be usi...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21769479.html
Zones:
MS SQL ServerDate Answered: 03/10/2006 Rating: 8.2 Views: 0
I get no errors, but nothing happens either. I want this to execute on page load:
Sub gejj()
Dim objconn As New SqlConnection("mystring")
objconn.Open()
try
...
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_21804151.html
