RajKishore 
In this SQL Server tutorial, we will learn what are Output Parameters in SQL Server Stored Procedure, How to use Output parameters in a stored procedure, and will cover the following topics. SQL Server stored procedure output parameter A stored procedure in SQL Server is a piece of SQL code that we can save and reuse over … Read more >>
In this article, you will learn about the SQL Server INSERT INTO SELECT statement. We use this statement when we want to insert a row into a table with the data from another table. We will see a number of examples using this statement. Also, we will see some use cases of this statement. For … Read more >>
In this SQL Server tutorial, we will learn about Foreign Key in SQL Server, create foreign key in SQL server 2019, Different examples related to Foreign Key in SQL Server, and will cover the following topics. Foreign Key in SQL Server Let us try to understand what is a foreign key in SQL server? So, in this section, we … Read more >>
In this article, you will learn what is Identity column in SQL Server. We will see how to use it and also see some examples. An identity column is a column in the SQL Server table that generates keys automatically for the records in the table. How to set identity column in SQL Server In … Read more >>
In this SQL Server tutorial, we will learn how to the IDENTITY_INSERT in the SQL Server. We will learn why we use the IDENTITY_INSERT property in SQL Server 2019. In this article, we will learn how to use the IDENTITY_INSERT property on the SQL Server table. We will also learn about the topics related to … Read more >>
In this SQL Server tutorial, we will learn How to add a column in the SQL Server table, Different examples related to adding a column, and will cover the following topics. SQL server add column with default value In SQL Server, we can specify a default value for a column in SQL server 2019, and it … Read more >>
In this SQL Server tutorial, we will learn How to convert Datetime datatype to String in SQL Server, Different SQL Server convert DateTime to string examples, and cover the below topic. Here, I have used sql server management studio and sql server 2019. SQL Server Convert Datetime to String Format There are mainly 2 functions … Read more >>
In this sql server tutorial, we will see, how to execute function in sql with parameters and we will see a few examples: How to execute user-defined function in SQL with parameters A user-defined function is a function created by a user and will perform an operation specified by the user. In this section, we … Read more >>
In this PostgreSQL tutorial, we will learn how to restart PostgreSQL services or servers in various platforms like Windows, Mac, and Linux. Also, we will cover these topics: How to Restart Postgres Service In this section, we will see why do we need to restart the PostgreSQL services on various platforms like Windows, Mac, and … Read more >>
In this PostgreSQL tutorial, we will learn how to uninstall PostgreSQL from different operating systems. The possible reasons for uninstalling PostgreSQL could be the project is complete and you don’t need PostgreSQL, the software is at fault or broken, unable to update the PostgreSQL so want to reinstall with the latest version, etc. How to … Read more >>