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

    • Now right click on database(which is hilighted in blue), and select new database from the dropdown.
    • Now give a name to the database here i have named it ExploreRoots. You’ll see that under the Logical Name column same name gets filled which you have in Database name. Let the Owner bee <default>.# Now this was a way to create the database without any query but if we want to create a database  with query we have another way

     

     

     

     


    previous next
 
Exploreroots: Copyright@