RajKishore 
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 PostgreSQL tutorial, we are diving into the realm of database management by demonstrating how to install PostgreSQL on a Windows operating system. Download and Install PostgreSQL on Windows To download and install PostgreSQL on Windows, follow the below steps. Step 1: Download PostgreSQL From the official PostgreSQL website, first download the Windows installer. … 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 >>
In this SQL Server tutorial, we will learn how to resolve the “Error: 40 – could not open a connection to sql server” error. So, in this tutorial, we will discuss the root cause of this error and will also discuss how to solve this error. Error: 40 – could not open a connection to sql server … Read more >>
Last week, I worked on a stored procedure in SQL Server. I got an error while working on the query about adding the values in the table. The error came as “String or Binary Data would be Truncated in SQL Server”. String or Binary Data would be Truncated in SQL This is a common error … Read more >>
In this PostgreSQL tutorial, we will learn about “Postgresql generate_series” which helps in generating series of numbers, dates, months and row numbers, etc. Postgresql generate_series In Postgresql, we use the generate_series() function to generate series of numbers. Use the below command to generate series of numbers: Syntax: Postgresql generate_series function accepts three parameters: Note: The … 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 >>
You may have faced scenarios when you need to change the password of your Azure SQL database. In this article, we will explain various ways to achieve this. How To Reset Azure SQL Database Password Let us discuss all the approaches individually. Approach-1: Using Azure Portal To reset Azure SQL database password, follow the below … Read more >>
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 >>
Free 40-page PDF
Download a free 40-page PDF with the top 200 SQL Server interview questions and answers, and prepare with confidence.
Your SQL Server interview questions PDF is on its way to . Can't find it in a few minutes? Look in your Promotions or Spam folder.