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 »
In this article, we will see how to install MySql in the Ubuntu machine. MySql can be installed in linux based machines through the terminal window Execute the command “sudo apt-get install mysql-server mysql-client” from the terminal. The below-given picture is for reference. You will be asked to enter the machine password here. Give the… Read More »
In SQL server, ALTER TABLE statement is used for the following purposes ADD columns/ constraints in the existing table. DROP columns/ constraints in the existing table. ALTER columns in the existing table. ENABLE/ DISABLE triggers. ADD columns/constraints Syntax to add columns and constraints while creating column Syntax to add column(s) One or more columns can… Read More »
In this post, we will see how we can connect to Teradata using the JDBC connection in Java using the credentials and copy the contents of the table to a CSV file. JDBC stands for Java Database Connector which is nothing but a set of libraries that will have supported functions to communicate with Teradata… Read More »
Microsoft SQL Server provides a nice feature of creating a table on the fly along with the data from another table using “Select into” statement. Syntax columns – Columns to be retrieved from the existing table. newTableName – Name of the new table to be created. existingTableName – Source table with data. conditions – Conditions… Read More »
In Microsoft SQL Server, there are different ways in which we can create the table. The table can be created with or without constraints. Basic Syntax for creating a table is, databaseName – Name of the DB where the table will be created tableName – Name of the table. columnName – Name of the column… Read More »
There are different types of statements that can be executed in SQL Server for different purposes. These are basically categorized into four types DDL – Data Definition Language DML – Data Manipulation Language DCL – Data Control Language TCL – Transaction Control Language DDL(Data Definition Language) The name itself suggests that it defines the structure… Read More »
BTEQ stands for Batch Teradata Query. It is one of the utilities in Teradata to perform DDL and DML queries, creating macros, etc. However, the BTEQ export feature is exclusively for exporting the result of a query to a file. BTEQ modes There are two modes of running BTEQ. They are interactive mode and Batch… Read More »