SQL | dbblogger 6/7

T-SQL Script to generate Six Digit One Time Password (OTP)

This blog will give a T-SQL script o create and use Six Digit One Time Password using the SQL Server RAND function

Steps to change the default SQL Server backup directory

This article provides steps to change the default SQL Server backup directory.

Learn SQL SELECT TOP statement

This SQL tutorial will understand how to use the SQL SELECT TOP queries using various examples.

"Invalid Object Name" Error in SSMS for recently created objects

Suppose you created a new table in SQL Server or Azure SQL Database, and the query editor shows you the error message "Invalid Object Name"