Tag: sql

SQL Server – Create two tables with primary and foreign key with SQL code

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

Tagged with: , , , ,

SQL Server – Create Custom View in Microsoft SQL Server Management Studio

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

Tagged with: , , ,

Python – SQL Alchemy or plain SQL ?

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

Tagged with: , , , ,

Python / Sqlite3 – Make a DB with Python

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

Tagged with: , , ,