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
From the course: SQL Server Machine Learning Services: Python
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.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.