From the course: Complete Guide to Advanced SQL Server
Join today to access over 24,400 courses taught by industry experts.
Python syntax pitfalls - SQL Server Tutorial
From the course: Complete Guide to Advanced SQL Server
Python syntax pitfalls
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 these skills and habits that you've developed from working with Transact-SQL scripts, and try and 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 correlation settings of the server. This means that SQL Server doesn't care if you use uppercase or lowercase letters. A…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
