sql example

Delete Horizontal White Space in SQL Serve

When you are required to import data received from different different file format such as .txt, .csv., or excel files, sometimes you see a white… Read More »Delete Horizontal White Space in SQL Serve

SQL ROLLBACK Transactions

SQL ROLLBACK transaction statement rolls back an explicit or implicit transaction to the beginning of the transaction. If a savepoint is specified, it rolls back… Read More »SQL ROLLBACK Transactions

SQL Server Computed Columns

A computed column is a virtual column which is used to add a new column to a table with the value derived from the values of other columns in the same table.

Computed column is not physically stored in the table, unless column is marked PERSISTED and it is persisted only if its expression is deterministic.

Identify blocked processes or long nunning query in SQL Server

Blocking occurs when a process hold a lock and other process has to wait till the first process completes.

SQL Server CUBE

CUBE operator is used to calculate subtotals and grand total for all combinations of grouping columns specified in the GROUP BY clause.

Temporary table / temp table in SQL Server

Temporary or Temp tables are tables that exist temporarily on the SQL Server.

SQL SERVER Interview Q & A QUIZ on SUBSTRING()

SQL interview question and answer on Substring function

SQL Q & A on SELECT Statement

Q 1 > SELECT Count(1) as Output 1> NULL 2> Error 3> 1 4> Invalid select statement Answer Q 2 > SELECT Count(*) as… Read More »SQL Q & A on SELECT Statement

SQL FOREIGN KEY Constraint

A foreign key is a key used to link two tables together. This is sometimes also called as a referencing key , usually a primary key table is considered as a parent table while a foreign key table is considered as a child table .