The DROP TABLE command in SQL Server will do as it suggests and drops a table. This post is to share an example of using the command, including the IF EXISTS argument which allows us to conditionally drop the table (does not cause an error).
This post is a guide on how to get the DateTimes for when your databases were last restored in SQL Server.
This post is a guide on how to list all SQL Agent Jobs on a SQL Server Instance, by using a TSQL script that queries system tables for this information.
This post is a guide on restoring a database in SQL Server via command (SQL). Restoring a database in SQL Server is a straightforward task, and one that SQL Database Administrators have to perform thousands of times throughout their career.
SQL Server 2022 was announced last week at the Microsoft Build event, which is an annual summit aimed at those of us who are enthusiastic about Microsoft software.
Some time ago I wrote short blog post on why use WHERE 1=1 in SQL. This time it’s why use WHERE 1=2, but really this can be WHERE 1=9 or anything that isn’t a 1, we just want the false statement.
Finding strings in SQL is usually done within a WHERE clause – you’re searching for rows in a table containing your condition which can of course include a string.
When performing data analysis of email data in SQL, there’s often a need to show only the domain of an email address.
The Use command in SQL Server is a way to change context to a specified database, which I often refer to this as scoping to a database for a query.
When you log into SQL Server using SQL Server Management Studio (SSMS), opening a new query window will automatically scope you within the default database set when your user was created.
author: Peter Whyte
