The IF statement we looked at on Tuesday was pretty tame compared to the WHILE construct.
Actually, the main thing you need to keep in mind is that WHILE is all you have. There is no such thing as a FOR loop or a DO WHILE loop. So, you have to force WHILE to do those for you.
The basic syntax of WHILE looks like this:
Continue reading “SQL WHILE – SQL For Programmers”
Many times in our queries, we aren’t looking for an exact match. We are looking for one string that exists in another. There are a couple statements available to us that will allow us to do this.
The first of these is the LIKE statement, and if you are familiar with DOS or the Linux equivalent, this should look familiar to you.
Continue reading “SQL For Programmers – Finding a String”
Today, I finally announce the availability of my new book. SQL For .NET Programmers.
This book is based on the series of post I wrote in 2008. If those post have been valuable to you and you’d like to have them all in one place on your Kindle reader, pick up your copy today.
Last week we looked at the extension points Microsoft has wired into the LINQ to SQL classes and how they can be used to achieve some of the capabilities of the Business Logic Layer (BLL) in a multi-layered architecture.
Continue reading “Computed Columns Using LINQ to SQL Classes”