How to create DATA BASE And Tables in MSSQL Server

Step 1.  Press Windows Button in that search for SSMS, Image will appear like this                           click on this image Microsoft SQL Server Management Studio window will open.

Step  2.  Enter Server name if it’s not available as default, else connect to default server  by pressing  connect in login window.

Step  3. After perfectly login a window will open in that a sub window by name Object Explorer will be there.




Step 4. In Object Explorer  right click  on the Data Base in that press new Data Base.






Step  5.  Type any name in Database name bar. As I have created a new database as tested which will be explore in Databases in Object Explorer.


Step 6. Explore the database which you have created as I have created database by name tested I am exploring my database in that go to tables.





Step 7. Right click on tables to add new table.



Step 8. After clicking on new table Insert the requirement . As I am creating table for employee I am putting my requirements as EmpId, Empname,Email,Phoneno. One should keep in mind that while creating the database space should not be used in between & primary column should not be allow as null. Nvarchar takes both char and variables.



Step 9. After inserting values set the primary key .



Step 10. After setting primary key auto-increment the table.If we have to use multiple to use in the table as multiple accounts or employees  we have to use auto increment in the table.

Comments

Post a Comment

Popular posts from this blog

CREATING INTERNET APPLICATION PROJECT & MVC USING DATA BASE FIRST APPROACH

In this we are going to see about how to create a project in visual studio and the concept of mvc. Here in this demo we are creating internet application base project. Step 1: Open the Microsoft Visual Studio. Go to File in that go to new and select Project. In new project select Visual C# , In that  select ASP.NET MVC 4 Web Application. After selecting the project type give the name of the project and the desired location where you want to save your project and press ok. In my case I am giving my project name as my first project. After pressing ok a page will appear for selecting template to which we want to run our project. Here we are selecting our template as Internet Application. Internet Application is a account controller that uses forms and authentication. Our view engine will be Razor. After pressing ok project is generated. Now let us see about MVC (MODEL VIEW CONTROLLER). Model : It should be responsible for the data of a...
Read more

Real Time Example add dynamic fields using jquery looking Treeview

I have Implemented add Dynamic Fields Using jquery Look at code : <html> <head> <title>Dynamically add input field using jquery</title> <style> .container1 input[type=text] { padding:5px 0px; margin:5px 5px 5px 0px; } .add_form_field {     background-color: #1c97f3;     border: none;     color: white;     padding: 8px 32px;     text-align: center;     text-decoration: none;     display: inline-block;     font-size: 16px;     margin: 4px 2px;     cursor: pointer; border:1px solid #186dad; } input{     border: 1px solid #1c97f3;     width: 260px;     height: 40px; margin-bottom:14px; } .delete{     background-color: #fd1200;     border: none;     color: white;     padding: 5px 15px;     text-align: center;     text-decorati...
Read more

Nullable Type In C# with Example

IN THIS  POST WE WILL LEARN    1. NULLABLE TYPE IN C#    2. NULL COALESCING  OPERATOR   ??   Type in C# In C# types are divided into 2 broad Categories Reference Types :  Interface , Class , Delegates , Arrays E.t.c Value Types        : Int , Float , Double , Structs ,Enums E.t.c By Default value types are non nullable. To make then nullable Use   ? int r= 0 (r is non nullable, so r cannot be set null , r= null will generate Error ) int? m =0 (m is nullable int , so m=null is legal) Example :  Nullable Type  In C# using System; namespace NullableTypeInCshape {     class Program     {         static void Main(string[] args)         {             bool? AreYouvirgin = true;             if (AreYouvirgin ==true)         ...
Read more

Data Type Conversions in C# with real time example

In This Post We Will Learn   Data Type Conversions 1.   Implicit Conversions 2.   Explicit  Conversions 3.   Different between Parse() and TryParse() Implicit Conversion is done by the compiler  1.  When there is no loss of  information if the conversion is done  2.  if there is no possibility of throwing  exception during the conversion  Example :  Converting an int to a float will not loose any data and no Exception will be thrown, hence an implicit conversion can be done. using System; namespace Datatypes_conversion {     class Program     {         static void Main(string[] args)         {            // Implicit Convertion Real Time Example              int r = 100;             float m = r;    ...
Read more

Basic -C# Reading and writing to a console

     * Reading From the Console      * Writing to the Console      * Two Ways To Write Console            1)  Concatenation             2)  Place Holder Syntax Reading and Writing to Console  using System; //  A Namespace is used to Organize your code and is Collection of Classes     class Program     {         static void Main()  // Main Methods          {             // Prompt The User For His First Name              Console.WriteLine("Enter First Name");             // Read the name from Console              string firstname = Console.ReadLine();             // Prompt the User For His Last Name   ...
Read more