With example how to get only the common records from two tables using INTERSECT and the advantages of INTERSECT over INNER JOIN.
Get only the common records from two tables using INTERSECT
Author: Beaulin Twinkle
Get records from one table which are not present in another table using EXCEPT
Getting records from one table which are not present in another table using EXCEPT operator in SQL Server.
Concatenate columns to string in SQL Server
In SQL Server there are several ways to concatenate columns to a single string. Here are few methods for concatenating columns based on the version of SQL Server.
Formatting SQL statements in SSMS
Formatting SQL statements or source code of procedures or function in SSMS is a daunting task. Here you will see how to use a plugin to format T-SQL in SSMS.
Creating code snippet for Python Django web app in VS Code
It will be a good practice to create a code snippet instead of copy paste the template code in several files. Creating code snippet for Python Django web app in VS Code.
Using database in Python Django website
Simple step by step illustrations for using database in Python Django website. Here we will be using SQLite database.
Adding image to Python Django web app
Adding images and other media files is same as adding other static files. Sometime you may need to segregate images in a separate folder.
Creating website with Python using VS Code on macOS
Step by step instruction on how to use Python for website development using Django as the web framework, Visual Studio Code as the editor on macOS.
How to copy a file in Python?
Here is a simple way to copy a file in Python programming using one of the copy methods in shutil library module.
How to get a sub-string from a string in Python
There are several ways to get a sub-string from a string in Python programming. Here we will see a simple slicing techniques to get sub string.
How to find the current directory of the script file in Python?
Here is a simple method to find the current directory of the script file in Python programming using a method from the os module.
Manually raising exception in Python
Sometime you may need to manually raise exception in Python programming instead of thrown automatically.
Get the last element of a list in Python
There are couple of simple ways to get the last element of a list in Python programming. Let us see both these methods with samples.
How to find number of elements in a list in Python?
Here is a simple tip to find the number of elements in a list in Python programming. Get the count of elements in a list.
Converting string to datetime object in Python
Here we will see simple tip to cinvert a string to datetime object in Python programming using the datetime.strptime() method.
How to check and parse a string to float in Python?
To check and parse a string to float, I wrote two simple functions. One of the function checks for float and the other converts the string to a float.
How to concatenate multiple lists in Python?
There are couple of efficient ways to merge / join / concatenate multiple lists in Python programming. Let’s see how to use them with example.
How to write data from list to a file in Python?
Here we will see how to write date from list to a file. We will also see a simple technique to write every list element in separate line in the file.
Reading a file into a list in Python
Here we will see how to open the file, read the contents to a list variable with a line per list item. Reading a file into a list is quiet simple in python.
Upgrade python version in visual studio code python workspace
Simple steps to upgrade python version in visual studio code python workspace environment. Upgrading python virtual environment in VS Code.