So far, we’ve examined how to use the SELECT statement in SQL to create SQL Views for use in Crystal Reports, and as List Views in TMS. Now we are going to use the SELECT statement to create an alert in TMS. (more…)
Category: SQL Scripting
-
![Select Top 3 * From [Uses for Select]: Part 3](https://petrovay-com.s3.us-east-2.amazonaws.com/three-flickr-16206784972.jpg)
Select Top 3 * From [Uses for Select]: Part 3
-
![Select Top 3 * From [Uses for Select]: Part 2](https://petrovay-com.s3.us-east-2.amazonaws.com/two-flickr-6858448447.jpg)
Select Top 3 * From [Uses for Select]: Part 2
-
![Select Top 3 * From [Uses for Select]: Part 1](https://petrovay-com.s3.us-east-2.amazonaws.com/one-flickr-4103318176.jpg)
Select Top 3 * From [Uses for Select]: Part 1
People generally ask me about resources for learning SQL. SQL is a great language for any database administrator to learn, because it gives you full control of the data, without limiting you to an application’s graphic user interface (GUI). With SQL you can query for records, and add, edit or remove them. This post is not meant as a tutorial on the subject, because great resources, like SQLzoo or O’Reilly’s , already exist. Instead, in this series of posts, I want to highlight why the
SELECTstatement is the most important of these. (more…) -
Looking for What Isn’t There
My coworkers seem to have an “infinite capacity to not know what can’t be done,” manifest in the myriad of queries they want to perform within TMS. Not satisfied with searching for records that meet a criteria, they’d rather look for records that don’t. (more…)