Skip to content

Tag Archives: SQL-Server

In this article, we will see, how to delete certain rows based on comparisons with other tables. We can perform the function by using a… Read More
In this article, we will look at how to convert Date to Datetime. We can convert the Date into Datetime in two ways.  Using CONVERT()… Read More
SQL logical operators are used to test for the truth of the condition. A logical operator like the Comparison operator returns a boolean value of… Read More
Here we will see, how to export SQL Server Data to CSV file by using the ‘Import and Export wizard’ of SQL Server Management Studio… Read More
In this article, we will see how to use GROUP BY to count the number of rows for each unique entry in a given table.… Read More
In this article, we will see how to use NULL values inside NOT IN Clause in SQL. NULL has a special status in SQL. It… Read More
Here we will see, how to read a text file with SQL Server. We can read the text file using the OPENROWSET(BULK ) function. OPENROWSET(BULK)… Read More
Here we will see, how to escape square brackets in a LIKE clause. LIKE clause used for pattern matching in SQL using wildcard operators like… Read More
In this article, we will see how to use CASE in the ORDER BY clause to sort records by the lowest value of 2 columns… Read More
A Database is defined as a structured form of data that is stored database a computer or data in an organized manner and can be… Read More
There can be many columns in a database table, so sometimes it can become difficult and time taking to find the same type of data… Read More
The Update statement is a SQL keyword to update data in the database. We can update all the rows in the database or some values… Read More
SQL stands for Structured Query Language. It is a language used to interact with the database, i.e to create a database, to create a table… Read More
Here we will see SQL statements to remove part of the string. Method 1: Using SUBSTRING() and LEN() function We will use this method if… Read More
In this article, We will learn what is a Composite Primary Key and How will create a Composite Primary Key. As We know a Primary… Read More