The documentation for GetProcAddress explains that you pass the integer ordinal in the low-order word of the lpProcName parameter. The MAKEINTRESOURCE macro can actually be used to make this a little easier: int ordinal = 123; HANDLE dll = LoadLibrary(“MyDLL.dll”); FARPROC fn = GetProcAddress(dll, MAKEINTRESOURCE(ordinal));
I’d use it: If you love troubleshooting Creating adhoc queries without intellisense There is no upside. SQL Server only supports in the ORDER BY anyway. Anywhere else it’s an expression to be evaluated.
It’s a function which is a lot simpler than you think. Though there might be a .NET function already in existence for this, the following function (written in PHP) does the job. It shouldn’t be too hard to port it over. function ordinal($num) { $ones = $num % 10; $tens = floor($num / 10) % … Read more
If you know quantity of columns, but don’t know its names and types, you can use following trick: select NULL as C1, NULL as C2 where 1 = 0 — Returns empty table with predefined column names union all select * from Test — There should be exactly 2 columns, but names and data type … Read more
Here’s a terse solution taken from Gareth on codegolf: ordinal = lambda n: “%d%s” % (n,”tsnrhtdd”[(n//10%10!=1)*(n%10<4)*n%10::4]) Works on any number: print([ordinal(n) for n in range(1,32)]) [‘1st’, ‘2nd’, ‘3rd’, ‘4th’, ‘5th’, ‘6th’, ‘7th’, ‘8th’, ‘9th’, ’10th’, ’11th’, ’12th’, ’13th’, ’14th’, ’15th’, ’16th’, ’17th’, ’18th’, ’19th’, ’20th’, ’21st’, ’22nd’, ’23rd’, ’24th’, ’25th’, ’26th’, ’27th’, ’28th’, ’29th’, ’30th’, … Read more
This page gives you a complete listing of all custom numerical formatting rules: Custom numeric format strings As you can see, there is nothing in there about ordinals, so it can’t be done using String.Format. However its not really that hard to write a function to do it. public static string AddOrdinal(int num) { if( … Read more