SQL Server codemodes

Create SQL Server Database

In SQL Server by Baqir Ali

In order to work or practice T-SQL, we should learn to create a database first. We are using SQL Server Management Studio to create a database and T-SQL. The database will be called Codemodes

  1. Open Microsoft SQL Server Management Studio 2014 or other.
  2. Go to object explorer to the right of the window.
  3. Right-click on the Databases
  4. Go to Create New Database
  5. Give a database name as “codemodes”

Or you can create the database using code also

  1. Open Microsoft SQL Server Management Studio 2014 or other.
  2. Click on New Query button
  3. Type the following code
create database codemodes

Now select the code press F5 or click on execute

Support us by sharing this post