[Solved] What is the difference between OUTER APPLY and OUTER JOIN, and when to use each? [closed]

First, I do not really know which is the default OUTER JOIN in T-SQL (I’d bet FULL), but in any case, I think it is unclear – it is best to use LEFT, RIGHT, OR FULL JOIN explicitly when you need one. JOIN joins tables. Already existent ones or subqueries. APPLY applies (duh) a table-valued … Read more

[Solved] How to do the c# string.split() in oracle

Replace the prefixes you want to remove, then find the index of the first and second underscores and then find the substring between those two separators: Oracle Setup: CREATE TABLE your_table ( value ) AS SELECT ‘DUM_EI_AO_L_5864_Al Meena Tower’ FROM DUAL UNION ALL SELECT ‘EI_AE_L_5864_Al radha Tower’ FROM DUAL Query: SELECT value, SUBSTR( replaced_value, first_separator … Read more

[Solved] What’s the problems on this sql command code? [closed]

It looks a bit bulky, I’d recommend you to rewrite it in the following way: SELECT User1.NAME,User1.PORT,User1.IP,File1.SIZE, FROM [User_File],[User1],[File1] WHERE [User_File].UID= User1.UID AND [User_File].FID=File1.FID and [User_File].FID = {0} and check if it runs without errors from your SQL Management Studio. solved What’s the problems on this sql command code? [closed]

[Solved] T-SQL to generate expect result

Assuming that I understand the problem: you have a number of rows with sections (“Cates”) and symbols (“Type”); if there are any symbols ending in a minus sign then these indicate a row without a minus sign should be removed; symbols are never “mixed” per section, i.e. a section can never have “A” and “B-“; … Read more