Electron microscopy
 
Access and use SQL Database on SSMS (Microsoft SQL
Server Management Studio Express) with pyodbc
- Python for Integrated Circuits -
- An Online Book -
Python for Integrated Circuits                                                                                   http://www.globalsino.com/ICs/        


Chapter/Index: Introduction | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | Appendix

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

Access and use SQL Database on SSMS (Microsoft SQL Server Management Studio Express) with pyodbc:
         The steps are:
              i) Create a "New Database":
                   Upload Files to Webpages   
                   Upload Files to Webpages
              ii) Create a "New Query" with "use ...", and then Refresh the database: Code:
                   Upload Files to Webpages
                   Upload Files to Webpages
             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):          
         Upload Files to Webpages
             iii.a.2.a) Use WHERE clause to extract specific lines with some data name.  Code 2a:          
         Upload Files to Webpages
       Output:    
         Upload Files to Webpages
             iii.a.2.b) Or Code 2b:          
         Upload Files to Webpages
       Output:    
         Upload Files to Webpages
             iii.b) Code option 2:  Code 2
         Upload Files to Webpages
       Output:    
         Upload Files to Webpages
            Insert a row:  Code 2
         Upload Files to Webpages
       Output:    
         Upload Files to Webpages
           Update and count updated rows:  Code
         Upload Files to Webpages
       Output:    
         Upload Files to Webpages
           Delete rows:  Code
         Upload Files to Webpages
       Output:    
         Upload Files to Webpages
     The code below is to access the SQL code directly on SSMS:          
         Upload Files to Webpages  
       Output:    
         Upload Files to Webpages

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

         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         

 

 

 

 

 



















































 

 

 

 

 

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