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.
Category :SQL Scripting
Select Top 3 * From [Uses for Select]: Part 2
In Part 1, we examined how to use the SELECT statement in SQL to create a SQL View that can be used in Crystal Reports for reporting. There are two additional uses for the SELECT statement, which make learning its syntax an invaluable tool for database administrators.
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 …
Accessioning Clean-up: Part 1
Whether you are launching a data cleanup project or simply want to verify that standards are being followed, there are times you want to be able to quickly and easily manage your data. In 5 (Often Forgotten) Productivity Tools I mentioned that are a great way to review data. In the first part of this …
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.