Commitecdff86

authored

Update README.md

1 parent34e1fbf commitecdff86Copy full SHA for ecdff86

File tree

-7

lines changed

-7

lines changed

Lines changed: 3 additions & 7 deletions

Original file line number	Diff line number	Diff line change
`@@ -47,16 +47,12 @@ Connect to SQL Server and execute a simple query:`
`47`	`47`	`import mssql_python`
`48`	`48`
`49`	`49`	`# Establish a connection`
`50`		`-connection= mssql_python.connect(`
`51`		`-server='your_server',`
`52`		`-database='your_database',`
`53`		`-username='your_username',`
`54`		`-password='your_password'`
`55`		`-)`
	`50`	`+# Specify connection string`
	`51`	`+connection="SERVER=<your_server_name>;DATABASE=<your_database_name>;UID=<your_user_name>;PWD=<your_password>;Encrypt=yes;")`
`56`	`52`
`57`	`53`	`# Execute a query`
`58`	`54`	`cursor= connection.cursor()`
`59`		`-cursor.execute("SELECT* FROM your_table")`
	`55`	`+cursor.execute("SELECT@@version")`
`60`	`56`	`rows= cursor.fetchall()`
`61`	`57`
`62`	`58`	`for rowin rows:`

Comments

(0)