Home » 2013 » May

Monthly Archives: May 2013

Advertisements

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

Please visit SQLVERSITY.COM for more details.

(more…)

Advertisements

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

Microsoft SQL Server

Please visit SQLVERSITY.COM for more details.

Microsoft SQL Server is a relational database management system(RDBMS) developed by Microsoft. As we already know that, database stores the data and we can retrieve/modify the data in database. SQL Server is not case sensitive. SQL Server uses T – SQL(Transact Structured Query Language) which is the extension of SQL. If you are strong in SQL basics, you can easily learn T – SQL.

(more…)