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 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.
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.