FAQ Database Discussion Community


LINQ equivalent of my SQL Query for UNION ALL

sql-server,linq,sql-order-by,union,equivalent
(SELECT * FROM SheetHay WHERE SheetStatus = 2) UNION ALL(SELECT * FROM SheetHay WHERE SheetStatus = 1) UNION ALL (SELECT * FROM SheetHay WHERE SheetStatus = 0) UNION ALL(SELECT * FROM SheetHay WHERE SheetStatus= 3) I get result set like this: I mean I get all '2' together, '0' together,...

ArrayList from java to C#

java,c#,list,arraylist,equivalent
This is Java code, how can I do this with C# static ArrayList<ArrayList<String>> test= new ArrayList<ArrayList<String>>(); test.get(index).add(s[1]); ...

Equivalent PHP code in C#

c#,php,equivalent
I know that $_POST['m_orderid'] in C# the equivalent will be Request.Form["m_orderid"]. What means in C#: $_POST['m_orderid'].'|success'; ...

Java equivalent of batch pause?

java,equivalent
I am using the following code to simulate a clear screen: for (int i = 0; i < 50; ++i) {System.out.println();} My problem is is that when I write something on the screen and then it goes back to where this code is, the text written is gone. I was...

C - test string equivalence without strcmp

c,string,equivalent
in one of my university assignments I am restricted in the libraries I use. I am new to C and pointers and want to see if two strings (or should I say char's) are equal. Part of me wants to loop through every char of the 'char string' and test...

Matlab equivalent of Python's 'reduce' function

python,matlab,reduce,equivalent
I have a bunch of matrices of the same size m*n: a, b, c, d, and I'd like to find the maximum of them elementwise, like: mx = max(a, max(b, max(c, d))); apparently the code above is not concise enough, I've googled and didn't find much help about max on...

How to convert this select from Oracle to SQL Server?

sql-server,oracle,equivalent
I need to know if the used INTO SQL Server and equivalent ROWNUM in SQL Server SELECT SERIE, CORRELATIVO INTO vSerie, vCorrelativo FROM SIG.SAF_SERIES_DOCUMENTOS_DET WHERE COMPANIA = pCompania AND MONTO = pMonto AND ESTADO = 'P' AND ROWNUM = 1; ...

SQL Server equivalent of Trunc

sql-server,oracle,equivalent
TRUNC(LD.FECHA_CREA) I need convert it to SQL Server...

JavaFX Transition Equivalent

java,javafx,transition,equivalent,interpolate
I have a non-gui application where I want to asynchronously interpolate some data over time. I had a look at the JavaFX Transition API and it looked ideal. However, for the transitions API to work it has to be run as part of a JavaFX application context - which I...