SELECT object_name, object_type, created, last_ddl_time, timestamp, status FROM user_objects; Run Operating System Commands from SQL*Plus One of my favorite commands in SQL*Plus is the host command.

An SQL Server-scheduled job can run database commands or it can run Microsoft Windows commands in standard executable program files or in the PowerShell scripting language.

SQL server will allow zero-length strings without issue, as long as your datatype supports it. Just assign the string value of ('') and you're done, no headaches.

We also discussed the ways to restore database backups using SSMS and T-SQL commands. In case the database backup gets corrupted, you can use a third-party tool, such as Stellar Repair for MS SQL ...

SQL (Structured Query Language) is a programming language used to communicate with and manipulate databases. Learn its history and when to use it.