Questions tagged [out-parameters]
145 questions
1
vote
2 answers
T-SQL - parameter assignment, data retrieval and comparison in one line - is it possible?
I want to do something like this in T-SQL, but it will return an error:
DECLARE @Stock int
IF(SELECT @Stock = [Stock] FROM dbo.Products WHERE [ProductID] = 1) > 5
PRINT 'Stock is good: Current stock is ' + @Stock
ELSE
PRINT 'Order some more…
Sha
- 2,185
- 1
- 36
- 61
1
vote
1 answer
How can I send out parameter to web method from jquery
Im triying to send out parameter to webmethod. I cant change web method because its not mine. I need to use it with only jquery.
Web method example;
[WebMethod]
public static string getValue(int id, out string name)
{
name = (id *…
cbalakus
- 620
- 7
- 15
1
vote
3 answers
Return value or out parameter for c# method that can return either a char or string?
I ran across some code during a code review that didn't seem right, but not sure the "best" way to change it. In looking for an a answer I found which is better, using a nullable or a boolean return+out parameter and Which is better, return value or…
Kevin Hakanson
- 41,386
- 23
- 126
- 155
1
vote
1 answer
SQL Server output and return value in procedure
I'm new to SQL Server, and i have this error that i was not able to fix:
Msg 245, Level 16, State 1, Procedure info, Line 11
Conversion failed when converting the varchar value 'Steven' to data type int
Can you please show me where is the error,…
andrea
- 396
- 2
- 12
1
vote
1 answer
Retrieving Oracle ADT / User Type metadata from JDBC
Following on from this question regarding how to retrieve/write Oracle Table Types from JDBC, is it possible to retrieve either the type metadata directly, or just the name of the type (which can then be combined with the Oracle driver's…
Andrew
- 777
- 1
- 7
- 19
1
vote
1 answer
Swift pointer to pointer to const char parameter
When interacting with a C api (the SQLite 3 C api) from Swift, I need to pass a pointer to a pointer to const char as an out-parameter:
sqlite3_prepare_v2(
// snip other parameters
const char **pzTail // OUT parameter
);
Which is translated into…
Ben
- 542
- 1
- 5
- 12
1
vote
1 answer
get out parameter value of stored procedure in classic asp
I am working with classic asp and using stored procedure. I have to get the value of stored procedure out parameter. This is my code
<% @LANGUAGE="VBSCRIPT" CODEPAGE="65001" %>