Data Definition Language (DDL) It is used to create, alter, or drop data structures in the database. 1. CREATE – to create objects in the
Tag: SQL
DELETE and TRUNCATE Command In SQL
Delete command removes the rows from a table based on the condition that we provide with a WHERE clause, whereas Truncate command will actually remove all
Basics Of Clustered And Non-Clustered Index In SQL Server
What is an Index ? Index is database object. It works the same way as book index do. It can be created on one or
SQL Dumper
Probably most of the developers may be knowing about SQL Dumper. SQL Server Dumper enables you to dump selected SQL Server database tables into SQL
Step By Step Installing Microsoft SQL Server 2012
1. Mount .iso file and click on setup.exe, you will see the following screen. 2. Click on “New SQL Server stand-alone installation or add features