Showing posts with label MSSQL - Create Table. Show all posts
Showing posts with label MSSQL - Create Table. Show all posts

Saturday, March 11, 2023

Create Table Using MSSQL SERVER

  • Click On Database Folder and Expand.
  • Right Click on Tables Folder.





  • Move 'New' and Click on Table



  • Display Table Design View
  • Enter Column Names and Select Data Type which you need.



  • Right Click on Column which you wish to selected as  Primary Key and Click on 'Primary Key'.



  • Click On 'Save' Button.



  • Give the name which you need for Table and Click 'Ok'






Now you Can See table in table Folder which you created.


SQL INSERT QUERY

This Command use for Insert New Record in to Table . INSERT INTO Syntax. INSERT INTO  < Table name > ( Table Column names ) values (...