Science

Hugh_Lebowski

(33,643 posts)

5. MS Sql Server is my main jam, and our biggest client uses it

Wed Mar 1, 2023, 05:43 PM

Mar 2023

But we have others on mySQL and some legacy Oracle stuff (which I hate).

Another task today is converting some SQL Server scripts to mySQL format as we need the same functionality on both platforms.

Thing that's pissing me off right now is that

Select top 1 * from table; (mssql)
and
Select * from table limit 1; (mysql)

Don't always work the same way. I mean if the query is THAT simple they do, but start adding a lot of other stuff (most of my queries are beasts), and they don't. Frustrating me as we speak

Edit history

Please sign in to view edit histories.

Recommendations

0 members have recommended this reply (displayed in chronological order):

11 replies

= new reply since forum marked as read

Highlight:

Python 3.14 Will be Faster than C++ (Not really) [View all] BootinUp Mar 2023 OP

Our shop has some big Python projects coming up and I've been asked to familiarize myself Hugh_Lebowski Mar 2023 #1

I setup and run a little sql server BootinUp Mar 2023 #2

MS Sql Server is my main jam, and our biggest client uses it Hugh_Lebowski Mar 2023 #5

Currently I use the MS product but I have BootinUp Mar 2023 #6

So is it due to a difference in how the results are sorted? BootinUp Mar 2023 #9

I assume this was some sort of joke lapfog_1 Mar 2023 #3

I guess you were bored and didnt BootinUp Mar 2023 #4

lol, I wrote a text preprocessor and HTML generator in R once mike_c Mar 2023 #7

I just used R to format and export data from MS SQL BootinUp Mar 2023 #8

You are SO right: It is the entire development cycle which is important SorellaLaBefana Apr 2023 #11

Python-based compiler achieves orders-of-magnitude speedups Jim__ Mar 2023 #10