How to create a database in SQL Server 2012 tutorial step by step
Hi Reders, Myself Khushbu Tyagi. In this tutorial I am going to explain you how to create a database in SQL Server 2012, 2008 or 2005. I will explain all types of way that you can create a Databae in SQL server. How to insert a database in SQL Server 2012 Tutorial Create database statement in SQL Server 2012, 2008 or 2005? How to create a database in sql server 2012, 2008 or 2005? SQL Create databse statement(Transact-SQL) Syntax.
I will explain you 3 ways to create a database in SQL Server any version It may be SQL Server 2012, SQL Server 2008 or SQL Server 2005. These are:
How to Create a Database in SQL Server 2012, 2008 or 2005 help of DATABASE Statement Syntax query?
How to create a database in SQL Server 2012 or 2008 help of SQL Wizard step by step?
How to create a database in SQL Server 2012, 2008 or 2005 help of Template Explorer?
Hi Readers, In my last articles on “How to create table in SQL Server 2012 step by step” and “how to install SQL Server 2012 step by step” I described about how to create a table and what is row, column and installation guide in SQL Server 2012 . Hope that gave you basic idea on it and how to use SQL Server. Now i will explain to you how to create database in SQL Server 2012 step by step. Now i am going to explain it.
How to create a DATABASE in SQL Server 2012 step by step SQL Statement Syntax tutorial
Before I explain All step to create a database, I want to explain you what is a database? and why we need a database?
What is a Database?
In programming language a database is a repository of information that contains data in an organized way. In my word database is a Book Library where you can store many types book in a category mean in a table and many categories stored in a library mean database.
In simply word a table can store multiple information related that table mean as I told if i guess a books category in a table. A book category in example computer book category is a table where you can store computer books name. and many types categories book example historical books and geographical books are store in database.
Now follow all steps to create a Database in SQL statement:
- Click Start Menu
- Click All Programs tab
- Click Microsoft SQL Server 2012, 2008, 2005
- Click on SQL Server Management Studio
5. Click on SQL Server Management Studio Connect button
/* How to create a database in sql server 2012 or 2008 step by step tutorial downloadfreetutorial.com Ranjan Kumar Bera */ CREATE DATABASE [SQL_downloadfreetutorial] /* or */ CREATE DATABASE SQL_downloadfreetutorial /* or */ /******Database [SQL_downloadfreetutorial]******/ CREATE DATABASE [SQL_downloadfreetutorial]
We see this because we have the SQL Server 2008 R2 installed. After connect SQL Server 2008 R2 or 2012
CREATE used to create a new database object, such as a table or database. CREATE, ALTER and DROP are include in Data definition languages (DDL) it is part of SQL statements categorized.
CREATE DATABASE statement is used to create a database. Database is used to store data in the database.
- Click on New Query
- Copy code From my page or type code in your SQL Server 2012 or 2008 Management Express.
- select it all, Ctrl + C to copy it, and Ctrl + V to paste it. and Select single statement and Press F5 key for Run or Click on Execute.
- See the output
- See the create database name if not then refresh object explorer.
- Enjoy Don’t forgot to give your valuable feedback and comment
- I will explain you 2nd part next tutorial how to create database help of wizard..
Enjoy this article for advance C# programming. wait for next article?? If there have any doubt any question please leave a comment. what type article you searching tell me by comment as soon as possible i will give you answer. <3
I hope you enjoy the tutorial, and best of luck!
This time i need some support from your side. I want you to comments my post. I shall be very thankful to you for this act of kindness. Please keep an eye for the next publication.
Please don’t forget to provide your valuable comments or suggestions.
Have a Query? Want to provide Feedback or Comments?