Calendar

May 2017
M T W T F S S
« Jun    
1234567
891011121314
15161718192021
22232425262728
293031  

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…)