How to remove special characters in PostgreSQL

Updated on by
Simple Example Replace Special Characters in Postgres Translate()

In this PostgreSQL tutorial, I’ll walk you through multiple proven methods to effectively remove special characters in PostgreSQL using the REPLACE() and REGEXP_REPLACE() functions. Additionally, you will learn to use the TRANSLATE() function, which can be used in conjunction with these two functions to replace special characters with new string values. How to remove special characters in PostgreSQL Sometimes your database contains a … Read more >>

SQL Server Convert String to Date + Examples

Updated on by
SQL Server Convert String to Date

In this SQL Server tutorial, we will discuss How to convert a String to Date in SQL Server, Different SQL Server Conversion Scenarios, and cover the below topic. All the examples, I have done here in sql server 2019 and SQL server management studio. SQL Server Convert String to Date When working with SQL Server, you may come across … Read more >>

How to Restart PostgreSQL (Linux, Windows, Mac)

Updated on by
restart postgres centos

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 >>

How to Uninstall PostgreSQL (Linux, Mac,Windows)

Updated on by
uninstall PostgreSQL in Ubuntu

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 >>

How to execute function in SQL with parameters

Updated on by
how to execute function in sql server with parameters

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 >>

IDENTITY_INSERT in SQL Server

Updated on by
SQL Server set IDENTITY_INSERT in a stored procedure

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 >>

Create Foreign Key in SQL Server – Complete tutorial

Updated on by
Create Foreign Key in SQL Server

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 >>

SQL Server Stored Procedure Output Parameter

Updated on by
stored procedure output parameter

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 >>

SQL Server INSERT INTO SELECT + Examples

Updated on by
sql server insert into select

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 >>

SQL Server select from stored procedure (9 Examples)

Updated on by
SQL Server select from stored procedure return table

In this SQL Server tutorial, we will learn How to select data from stored procedures in SQL Server and will cover the following topics. SQL Server select from stored procedure As the name implies, the SELECT statement in SQL Server is used to select data from a SQL Server table. And the data returned is saved in … Read more >>