Installation of python

   Part - 1

Below are steps to Install Python in your pc 

➔ Launch to browser and search for python or visit https://python.org

➔ once you click on https://python.org click on downloads

➔ Latest version will be visible on the top e.g. Python 3.9.4

➔ In case if you need a lower version, just scroll down the page and you can find all the lower versions 

➔ Click on the version you wish to install, then .exe file will be downloaded

➔ Double click on the downloaded .exe file, Python set up window opens, tick the check box 'Add Python 3.9 to PATH' and click on 'Customize Installation'

➔ You can also choose py launcher 

➔ Next ➔ Advanced Options

➔ Choose the location where you want to install ➔ tick check box 'Install for all users'

➔ Click on Install 

➔ 'Set up was Successful' on successful Installation

➔ Verify Python Installation

➔ You can verify python installation by launching command prompt 

➔ Run ➔ type cmd ➔ then type and then press enter

or     you can also verity by typing

This would display the version which has been installed

Thank you. If you like my video, please subscribe to my channel :)

 

Case Sensitive Search using SQL

   Part - 29

Link for video answer:

--********************************************************************************

-- Q29 -- Case Sensitive Search using SQL

--********************************************************************************

This can be achieved by changing the collation settings. If you set this at database level, this would be impacted by all the tables under that table. However you can use this with in Select statement with COLLATE so that it can to a Case sensitive Search.

If you want to see the current collation, use below query:

-- SQL_Latin1_General_CP1_CI_AS -- Case Insensitivity

--Latin1_General_CS_AS -- Case Sensitivity

Lets Illustrate with an example:

CREATE TABLE EmployeeName (EmpName Nvarchar(50))

INSERT EmployeeName VALUES ('Microsoft'), ('MicroSoft'), ('MICROSOFT'),('microsoft')

SELECT * FROM EmployeeName

This query returns all rows irrespective of the case sensitivity. We can use COLLATE to force use the Case Sensitivity or we can set at database level as well based on the requirement.

 

Using Collate, It retrieves only one record.

Thank you!. If you like this video, pls subscribe to my channel and like the video