Reputation
4,595
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
9 42 89
Impact
~510k people reached

Jan
15
comment Passing array parameters to a stored procedure
The accepted answer seems to answer D. Lamberts problem, but not the question taken verbatim. The question not only covers the case where the data comes from another stored procedure, but also the case where the data comes from ado.net or another API. This part is answered by sommarskog.se/arrays-in-sql-2008.html#ADONET which is mentioned in the above link. I think this link deserves to be included in this answer.
Jan
14
comment adding an order by to this query returns faster than without, why?
Where is the alias c defined?
Jan
14
answered Why can't I read Oracles CLOB columns via SQL-SERVER 2008 linked server?
Jan
14
comment Randomizing table contents and storing them back in the table
Which DBMS do you use and which data type has your key column?
Jan
14
comment How to return a CTE as REFCURSOR from an Oracle stored procedure?
@Leight Riffel Going to think about it this weekend. I'll try some Google queries and keep the part with more hits. BTW uses Orcale the term CTE or has it its own idiom?
Jan
13
accepted Did anybody use sqlcmd mode in practice?
Jan
13
accepted Is there anybody using the SQL Server feature to create groups of stored procedures differentiated by number?
Jan
13
accepted Can I change the SID of an Oracle database?
Jan
13
comment Can I change the SID of an Oracle database?
I renamed 4 oracle databases on a Windows Server this way. Searching for dbnewid utility I found oracle-base.com/articles/9i/DBNEWID.php which gave some additional explanations.
Jan
12
comment How to return a CTE as REFCURSOR from an Oracle stored procedure?
I started with one complete example. I think the the question deserves at least another example using input parameters. The special problem of sql-server -> Oracle migration pitfalls deserve(s) its own question(s).
Jan
12
revised How to return a CTE as REFCURSOR from an Oracle stored procedure?
Added one complete basic example
Jan
12
comment How to return a CTE as REFCURSOR from an Oracle stored procedure?
I agree. I googled about it half an hour an found no simple example which led me in the right direction. I only found it by the usual tactic of commenting out portions of the code. I guess this will soon become a CW.
Jan
12
answered How to return a CTE as REFCURSOR from an Oracle stored procedure?
Jan
12
comment How to return a CTE as REFCURSOR from an Oracle stored procedure?
Gotcha, missed it in the question
Jan
12
revised How to return a CTE as REFCURSOR from an Oracle stored procedure?
edited title
Jan
12
asked How to return a CTE as REFCURSOR from an Oracle stored procedure?
Jan
12
awarded  Citizen Patrol
Jan
11
revised How to compare performance of two versions of a function?
comparison fixed thanks to Matts comment
Jan
11
revised How to compare performance of two versions of a function?
1. Comment on answer
Jan
11
asked How to compare performance of two versions of a function?