From the course: SQL Server Machine Learning Services: Python

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Python syntax pitfalls

Python syntax pitfalls

From the course: SQL Server Machine Learning Services: Python

Start my 1-month free trial

Python syntax pitfalls

- [Instructor] The next movie in this chapter will introduce a challenge that I'd like you to work through to see if you can write a Python script that accomplishes a specific task. But before we get there, I thought it'd be good to take a quick aside and mention a few pitfalls that you might encounter when taking the skills and habits the you've developed from working with Transact-SQL scripts and try to apply them to this new world of Python programming. Right now, I have a script that we've written earlier in the course. It's the one that uses a while loop with a variable and outputs to the messages window. This script will run fine at the moment, but we can actually break it and start getting errors in some surprising ways. First, let's talk about uppercase versus lowercase characters. You might know that the T-SQL language is usually case insensitive depending on the colation settings of the server. This means that SQL Sever doesn't care if you use uppercase or lowercase letters.…

Contents