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 spaces along with the data, which may create a problem…

 192 total views,  1 views today

Read More...

SQL ROLLBACK Transactions


SQL ROLLBACK transaction statement rolls back an explicit or implicit transaction to the beginning of the transaction. If savepoint is specified then it rolls back the transaction to a savepoint within the transaction. Basically, it…

 1,358 total views,  7 views today

Read More...

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.

 226 total views

Read More...

Identify Blocked Processes or Long Running Query In SQL Server


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

 966 total views,  6 views today

Read More...

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.

 396 total views

Read More...

Temporary table / temp table in SQL Server


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

 462 total views,  1 views today

Read More...

SQL SERVER Interview Q & A QUIZ on SUBSTRING()


SQL interview question and answer on Substring function

 407 total views,  6 views today

Read More...

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 Output 1> NULL 2> 1 3> Error 4> Invalid select…

 153 total views

Read More...

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 .

 170 total views

Read More...

Truncate VS Delete statements in SQL Server


What is the Difference between SQL Truncate and SQL Delete statements in SQL Server ?

 174 total views,  2 views today

Read More...

How to access a data of table from another database in SQL Server?


How to copy a data of table from another database in SQL Server?

Suppose, you have a database1 and table1 and one another database2 and table2  in SQL server.

Now you are required to select data of a table1 of database1 from database2 of table2.

What would be a query for that?

 2,290 total views,  19 views today

Read More...