• Home
  • Tutorials
  • Info Seed
  • Forums
  • Projects
  • Links
  • Contact Us
SQL Server
HOW TO START...??
CREATING DATABASE
CREATING TABLE
INSERTION
INSERTION WITH QUERY
INSERTION OF NULL VALUE
SELECTION
USING DISTINCT
WHERE CLAUSE
AS IN SQL
OPERATORS
DELETE
UPDATE
LIKE OPERATOR AND WILDCARDS
BETWEEN OPERATORS
IN CLAUSE
ORDER BY
JOINS
UNION
INTERSECT
ALL/ANY
SQL CONSTRAINT
INDEX
DROP
Alter
FUNCTIONS
GROUP BY
HAVING CLAUSE
VIEWS

Insertion

  • To insert the data in the table go to the database where your table saved then open that database and click on tables, list of all tables on the right side would be shown as follow:
  • Now go to that table where you want to insert the values.
  • Right click on that table and from the options click on open table and a new windows open as shown below
  • Here you can fill the values (where null is written)according to the data_type you mentioned earlier for that table.

Example-3:

 

 

 

 

 

 


previous next
 
Lorem: Lorum | Ipsum | Dolar | Sic Amet | Consectetur | Lorum | Ipsum | Dolar | Sic Amet | Consectetur