Popular Posts

  • Retrieving the data posted to a JSP file from HTML file
    Now I will show you how to retrieve the data posted from a HTML file in a JSP page. Consider an html page that prompts the user to enter his...
  • SQL SUM
    The SQL SUM aggregate function allows selecting the total for a numeric column. The SQL SUM syntax is displayed below: SELECT SUM(Column1) F...
  • SQL HAVING
    The SQL HAVING clause is used to restrict conditionally the output of a SQL statement, by a SQL aggregate function used in your SELECT list ...
  • SQL Replication
    SQL Replication term describes a group of technologies allowing information distribution and mirroring between different databases. SQL repl...
  • SQL ORDER BY
    The SQL ORDER BY clause comes in handy when you want to sort your SQL result sets by some column(s). For example if you want to select all t...
  • SQL COUNT
    The SQL COUNT aggregate function is used to count the number of rows in a database table. The SQL COUNT syntax is simple and looks like this...
  • SQL GROUP BY
    The SQL GROUP BY statement is used along with the SQL aggregate functions like SUM to provide means of grouping the result dataset by certai...
  • SQL MAX
    The SQL MAX aggregate function allows us to select the highest (maximum) value for a certain column. The SQL MAX function syntax is very sim...
  • SQL IN
    The SQL IN clause allows you to specify discrete values in your SQL WHERE search criteria. THE SQL IN syntax looks like this: SELECT Column1...
  • JSP date example
    &lt%@page contentType="text/html" import="java.util.*" %&gt &lt!-- http://www.roseindia.net/jsp --&gt ...

Wednesday, March 18, 2009

Sql Server tutorials for beginners

Tutorials

Chapter 1 : What is SQL Server?
Chapter 2 : Compare SQL Server and MS Access
Chapter 3 : What is MSDE ?
Chapter 4 : SQL Server Editions
Chapter 5 : SQL Server service
Chapter 6 : SQL Server Instances
Chapter 7 : How to start and stop SQL Server service ?
Chapter 8 : Manage SQL Server services using SQL Service Manager
Chapter 9 : SQL Server 2005 Express
Chapter 10 : Limitations of SQL Server Express
Chapter 11 : Download SQL Server Express 2005
Chapter 12 : Installing SQL Server Express
Chapter 13 : Selecting authentication mode while installing
Chapter 14 : What is SQL Management Studio?
Chapter 15 : SQL Management Studio Editions
Chapter 16 : Connecting to SQL Server Database using Management Studio
Chapter 17 : How to use Management Studio ?
Chapter 18 : Manage the Databases
Chapter 19 : how to create a new database using Management Studio
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)