In the other post, we saw how to create tables in Teradata and the corresponding examples for each. Here we will see how to create a table with select from another table. In this post, we will see how we can create a table using select in Teradata. There are different ways in which we… Read More »
There are different ways to create tables in Teradata. We can also define the tables so that they will allow or not allow duplicates. We can also create tables with data from another table on the fly. Create table – Default We can create a table in Teradata with the default options By default, if… Read More »
In the previous article, I have explained about different ways to import JSON into SQL server. One of the ways is using OPENJSON function. In this article, I will explain OPENJSON function in SQL Server with some examples. OPENJSON is a table valued function that parses JSON document and transforms it into rows and columns.… Read More »
JavaScript Object Notation (JSON) is a lightweight data-interchange format. The JSON format is widely used to exchange data in most web and mobile applications. Also, the REST web services return results in JSON format. In this article, let’s see how to import JSON files into SQL Server. In SQL Server, you can import JSON documents,… Read More »
In this article, we will see the difference between ISNULL and COALESCE in SQL Server. Both ISNULL and COALESCE evaluates the expression for NULL and returns a non-null value. ISNULL The ISNULL function replaces NULL with a specified value. ISNULL ( check_expression, replacement_value ) It contains two parameters. The first parameter is to evaluate the… Read More »
In this article, let’s see various methods to implement pagination in SQL server. In SQL server database, a table can have N no of records. Populating all these records in a grid control slows down the web page. You need to divide the number of records and populate it in the web page. Pagination is… Read More »
One cannot avoid hearing the word “Hive” when it comes to the distributed processing system. In this article, we will see the hive architecture and its components What is Hive? What language does hive use? History of Hive Is hive a database? What is hive metastore? What are hive properties? Sample hive-site.xml file Hive architecture… Read More »
In the other article, we saw the usage of Table variables. In this article, we will see how to transform column values in a table to a comma-separated string. Let’s create a table variable “Teams” with the columns ‘ID’ and ‘Team’ (use the below script). When you fire a SELECT over the above table, it… Read More »
Table variables in SQL Server are variables that store a set of records in a table like structure for a particular period of time. It is another way of storing data temporarily similar to temporary tables. In this article, we will see what is table variable with an example. Generally, the name of the table… Read More »
A temporary table in SQL Server is a table that exists temporarily on the database server for a certain period of time. Temporary tables are basically stored inside the “tempdb”, which is a system database. Temporary tables are useful to work with a small subset of records in a table that contains a large number… Read More »