When working with data, you will often move between SQL databases and Pandas DataFrames. SQL is excellent for storing and retrieving data, while Pandas is ideal for analysis inside Python. In this article, we show how both can be used …
Python – Learn Pandas with SQL Examples – Football Analytics Example Read more →
In this article I will simply use the code from my first guest author Mathieu, to build up some small working solution, that uses parameters: So, the two classes, provided by Mathieu are here as well GitHub, named AdoValueConventer.cls and SqlCommand.cls. …
VBA – Using Parameters in a VBA SQL Query To a Database Read more →
There is a simple way in VBA and in Python to create tables in the database you need, giving the tables a name of a variable and the type of a variable. In SQL Server, we also have a way …
SQL Server – Create two tables with primary and foreign key with SQL code Read more →
Speaking about SQL, I have noted something really interesting in MS SQL Server Management Studio, which would probably be of use in MS Access as well. This is the saved custom view. It is not present in MS Access, but …
SQL Server – Create Custom View in Microsoft SQL Server Management Studio Read more →
Using SQL in Python reminded me of the “fun” I used to have in VBA MS Access, when I had to concatenate strings in VBA. Probably I was not the only one having “fun” and enjoying it, thus some good and …
Some time ago, I have built something like a primitive SQL language for C# here. Today, I have worked on a similar task, checking the powers of Sqlite3 with Python. This time it was not that primitive and the results were better …