=================================================================================

Access and use SQL Database on SSMS (Microsoft SQL Server Management Studio Express) with pyodbc:
         The steps are:
              i) Create a "New Database":
                      
                   
              ii) Create a "New Query" with "use ...", and then Refresh the database: Code:
                   
                   
             iii.a.1) Code option 1: Run the Python Code 1a (the first red line indicates the server name (if the Server is on your local PC, you can use localhost), while the second red line indicates the instance name (note: there can be multiple instances of SQL server on the same PC):          
         
             iii.a.2.a) Use WHERE clause to extract specific lines with some data name.  Code 2a:          
         
       Output:    
         
             iii.a.2.b) Or Code 2b:          
         
       Output:    
         
             iii.b) Code option 2:  Code 2
         
       Output:    
         
            Insert a row:  Code 2
         
       Output:    
         
           Update and count updated rows:  Code
         
       Output:    
         
           Delete rows:  Code
         
       Output:    
         
     The code below is to access the SQL code directly on SSMS:          
           
       Output:    
         

============================================