output-parameter Questions
2
Solved
I created a stored procedure which returns result rows and two output parameters.
I am unable to find any thing in spring from which i can get ResultSet and outPutParameters.
I want to achieve some...
Ricercare asked 15/2, 2018 at 10:29
3
Solved
I have written a stored procedure with the following format:
ALTER PROCEDURE usp_data_migration
(@sourceDatabase varchar(50),
@sourceTable varchar(50),
@targetDatabase varchar(50),
@targetTab...
Johnsen asked 11/1, 2014 at 4:28
3
Solved
I have a T-SQL stored procedure with the signature
CREATE PROCEDURE MyProc
@recordCount INT OUTPUT
@param1 INT
...
When executed directly in Sql Server the procedure runs in under 5 seconds, ret...
Respondence asked 7/5, 2009 at 11:25
1
Solved
I have a stored procedure returning a string and I need the result as a powershell variable. I'm stuck on the output parameter syntax.
Powershell script:
$SqlConnection = New-Object System.Data.S...
Aloft asked 17/6, 2015 at 18:31
2
Solved
I have an existing database with lots of complex stored procedure and I want to use those procedure through EF 4. I have done the following:
Created an EF data object, Customer.
Added a Stored Pr...
Oman asked 31/5, 2011 at 20:11
1
Solved
I have an output parameter @Counter and a temporary table #tmpUsers
Is it possible to assign the value of
SELECT COUNT(*) FROM #tmpUsers
To the @Counter output parameter?
I have tried
SET @...
Parodist asked 6/8, 2013 at 10:40
1
Solved
I'm having a bit of difficulty with this one in that I'm not sure how to do this in SQL Server.
Basically, I want to insert a new row into the database, get the PK value that was just inserted (sa...
Pollinosis asked 10/5, 2013 at 12:9
2
Solved
I'm using output parameters to return values from a stored procedure.
Declaration in stored procedure is : @GrandTtl DECIMAL(19,3) OUT
The SELECT query is:
SET @GrandTtl = (SELECT TOP 1 Bill_Am...
Dillydally asked 5/10, 2012 at 5:15
8
Solved
With a third party API I observed the following.
Instead of using,
public static string getString(){
return "Hello World";
}
it uses something like
public static void getString(String output)...
Idiomatic asked 10/9, 2009 at 7:55
5
Solved
Under System.Runtime.InteropServices the <Out()> Attribute exists.
But what is it for? I would be glad if you could use the following example as base for your answers.
Shared Sub Add(ByVal ...
Nightwalker asked 24/1, 2011 at 11:29
2
Solved
I'm looking for reasons beyond the usual "out parameters are confusing and indicate the method is doing more than one thing"-style arguments and more about what is specifically bad about output par...
Willin asked 19/1, 2011 at 9:41
1
© 2022 - 2024 — McMap. All rights reserved.