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

SQL SERVER

Sql server is basically a database it is used at the back end and also maintains the data . The queries mentioned in this topic are almost same for SQL, MySQL, MS-Access, Oracle and many other but we will discuss SQL sever in details i would try to give different queries for database where ever its different or possible.

Chapter1- How to start

  • First you have to install Sql server on your computer after that you open SQl Server management Studio Express, this is where you work. When you click on it a window would appear where you have to fill the name of Local server as to connect. The name of the Local server would be the computer name.

  • When you click on connect this window opens, the small green arrow in the left shows that your local server is working.

 

 

 

 


previous next

Lorem:

Lorum | Ipsum | Dolar | Sic Amet | Consectetur | Lorum | Ipsum | Dolar | Sic Amet | Consectetur