In this Azure SQL blog, I will share my incident when I got this error: “Cannot open server requested by the login. Client is not allowed to access the server“. Cannot open server requested by the login. Client is not allowed to access the server Recently, I was working with the Azure SQL database. I created … Read more >>
In this PostgreSQL, we will discuss How to Create a Table In PostgreSQL [Terminal + pgAdmin], for terminal psql which is an interactive terminal for interacting with the PostgreSQL database. Also, use the pgAdmin for creating the table which is the central hub for database management tasks. How to Create a Table In PostgreSQL Let … Read more >>
In this Oracle tutorial, we will learn how to add a column to a table in Oracle 19c and 21c. Moreover, we will also cover these topics. Oracle How To Add A Column To A Table While working on a database you received an email from the client to add a new column in the … Read more >>
This SQL Server tutorial will teach us how SQL Server Date Format dd mm yyyy works. Moreover, we will discuss and learn some examples so that you can understand the concept much better. SQL Server Date Format Example Let us discuss all the cases individually with proper examples. SQL Server Date Format mm dd yyyy In … Read more >>
In this SQL Server tutorial, we will understand how to see view definition in SQL Server. Additionally, we will also illustrate the following set of topics. But, before we start this topic, we recommend you learn about the basics of View in SQL Server. How to see view definition in SQL Server In this section, we will illustrate … Read more >>
In this SQL Server tutorial, we will learn how to create a table from view in SQL Server. Here we will illustrate this implementation using an example. Moreover, we will also cover the following topics. Create table from view in SQL Server In this section, we will learn to create a table using a view in SQL … Read more >>
While creating the function, I encountered an error and was unable to find the exact line. After several checks, I found the line number in SQL Server Management Studio. In this SQL Server tutorial, we will learn how to view line numbers in SQL Server Management Studio. View Line Numbers in SQL Server Management Studio SQL … Read more >>
I recently worked on creating the table and encountered an error. Errors are common in a development project. Exception handling or Error handling is an essential concept in software development. Like other programming languages, namely C, C++, and Java, SQL Server also provides exception handling. TRY and CATCH can handle errors in SQL Server. This … Read more >>
In this Oracle tutorial, we will learn about the rowid datatype in the oracle database. Also, we will illustrate how to use it to create rowid columns for a table in oracle. Oracle rowid Datatype The ROWID datatype in Oracle 21c stores the unique address of a row in a database table. It is 18 characters long … Read more >>
In this Oracle tutorial, we will learn how to change the name of the database in Oracle Database 21c, 19c, and 12c. Oracle change database name Oracle Database name can be changed using the NID tool, which is installed by default when installing Oracle Database 21c on the Windows operating system. Please note that the database … Read more >>