Category: SQL

SQL Query to Convert FLOAT to NVARCHAR

Here we will see, how to convert FLOAT data to NVARCHAR data in an MS SQL Server’s database table using the CAST(), CONVERT(), and FORMAT() functions.We will be creating a person table in a database called “geeks”.Creating the Database:CREATE DATABASE geeks;Using the Database:USE geeks;Table Definition:We have the following Employee table in our geeks database :CREATE […]

Continue Reading

Compare and Find Differences Between Two Tables in SQL

Structured Query Language or SQL is a standard Database language that is used to create, maintain and retrieve the data from relational databases like MySQL, Oracle, etc. Here we are going to see how to Compare and Find Differences Between Two Tables in SQLHere, we will first create a database named “geeks” then we will […]

Continue Reading

30 Days of SQL – From Basic to Advanced Level!

Structured Query Language or SQL is a standard database language that is used to create, maintain, destroy, update and retrieve the data from relational databases like MySQL, Oracle, SQL Server, PostgreSQL, etc. Whether you want to become a successful Data Scientist or a Business Analyst or a full-stack web developer or even a software developer, […]

Continue Reading