• Home
  • Tutorials
  • Interviews
  • Info Seed
  • Forums
  • Projects
  • Links
  • Contact Us
SQL Server
HOW TO START...??
CREATING DATABASE
CREATING TABLE
CREATING TABLE WITH QUERY
INSERTION
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

Creating Table

    • Click ok you’ll get a database created. Now you can see the database ExploreRoots  on the left side of the page.
      • Now under the database ExploreRoots  you can see 5 folders (like Database Diagrams, Tables etc), now on right click on the Tables folder(highlighted in blue in the snap shot) click on the first option i.e new table, as soon as you click on it another window opens (as shown below) where you give column name that are to be used in this table, its data type and there is a third column called ‘Allow Nulls’ if you tick this column that means null values are allowed in your table but if its not checked that means it would give an error if value is not filled in that column
      • Now close the Table-dbo.table_1 by clicking on cross on the right another window would appear which would ask you if you want to save the table click yes another small window would appear where you have to fill the name of the table (in here its Exr_Emp).

       

       

       

       


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