Calendar

April 2017
M T W T F S S
« Jun    
 12
3456789
10111213141516
17181920212223
24252627282930

Q8. What are ACID properties?

Please visit SQLVERSITY.COM for more details.

(more…)

Q7. What is the difference between REPLACE() and STUFF() functions?

Please visit SQLVERSITY.COM for more details.

(more…)

Q6. What is BCP?

Please visit SQLVERSITY.COM for more details.

(more…)

Q5. How to transfer the whole data from one table to another table which does not exists in database?

Please visit SQLVERSITY.COM for more details.

(more…)

Q4. What is the difference and similarities between local temporary table and global temporary table?

Please visit SQLVERSITY.COM for more details.

(more…)

Q3. How to DELETE duplicate records from a table?

Please visit SQLVERSITY.COM for more details.

(more…)

Q2. What is Row constructor/Table valued constructor in SQL Server?

Please visit SQLVERSITY.COM for more details.

(more…)

Q1. What is the basic difference between DELETE and TRUNCATE commands?

Please visit SQLVERSITY.COM for more details.

(more…)

Installing Adventureworks database

Installing AdventureWorks

Please visit SQLVERSITY.COM for more details.

My next article onward, we are going to start writing queries. So you should have some data to work on and which should be in sync with my data.

One of the possibility for you guys to get in sync with me is to install AdventureWorks database. This is a sample database which can be used for testing & practicing purpose. Let’s install AdventureWorks in your SQL Server.

(more…)

SQL Server Management Studio(SSMS) – The SQL Server UI

Connecting to  SSMS

Please visit SQLVERSITY.COM for more details.

Follow the below steps to connect & work with SQL Server.

Step 1: Click on Start button — All programs — Microsoft SQL Server 2008/2008 R2/2012 — SQL Server Management tudio

The following window appears.

(more…)