How To Create A Database and Table in SQL Server?

Total Post:24

Points:170
 185  View(s)
Ratings:
Rate this:


  1. Post:280

    Points:1994
    Re: How To Create A Database and Table in SQL Server?

    Step 1: First Create A Data Base

    Create Database APCRUD
    
      and Use APCRUD

    Step 2: – Create a Table like Customer

    Create Table Contact
    
    (
    ContactID int Primary Key Identity (1,1),
    Name varchar(50),
    Mobile varchar(50),
     Address varchar(250)
    )

    Then after -> Go to the objectExplorer window in a sqlserver and select database and done refresh -> select CRUD database and open it -> Select Table and done RightClick -> Select Edit Top 200 rows for insert some record and execute.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!