Members

Technology Zones

IBM Learning Center

Articles

Hosted By

Info

• Index
• / Databases
• / SQL Server
• / Web Sites

Web Sites

• Keep Sessions in SQL Server

  If your web server is part of a server-farm or you want additional security/control, then you can use web.config and SQL Server to store user session information in SQL Server.

• Chapter from "Teach Yourself ADO.NET in 24 Hours"

  Read Chapter 3 "Using T-SQL: A Crash Course" and learn how to retrieve, add, modify and delete data with the SELECT, INSERT, UPDATE and DELETE statements, and how to use some T-SQL built-in functions.

• Dynapage

  An easy way to create a fast, flexible and dynamic web application that runs from a Microsoft SQL Server.

• Vyas' SQL Server website

  This site features code samples, FAQ, articles, questions and answers.

• All about MS SQL Server

  SQL Server Articles, FAQ, Scripts, Tips and Test Exams.

• Why use Stored Procedures?

  An article explaining the pros and cons of stored procedures.

• Using SQLXML to display a report

  This example is focused on using the SQL Server 2000 SQLXML functions in asp pages. We will get data from data base in xml format and using xsl we will display data in asp page.

• Getting started with SQLXML

  SQLXML allows you to send queries to your SQL Server database and to be able to retrieve the results in XML over the web. This article will tell you how to set it up.

• Utilizing ASP to Provide Online Database Access

  A brief example of the process of creating an ASP page to access database information and then display it properly on a webpage.

• XML-ify your stored procedures

  We'll cover some of the XML SQL Server 2000 features and discuss using them in your stored procedures.

• XML and SQL Server 2000 Integration

  Covering the new XML support added to SQL Server 2000. In particular, you will learn about XML recordsets, URL-based queries, XML views/schemas, and how the addition of XSLT transformations can greatly simplify the delivery of XML data to disparate targets.

• What's New in SQL Server 2000

  Subjects covered will include the new data types, cascading DRI, user defined functions, INSTEAD OF triggers, XML, distributed views, and new and improved tools such as the T-SQL debugger in the Query Analyzer and the Copy Database wizard...

• Fundamentals of DTS in SQL Server 2000

  Microsoft has added an enormous amount of features to DTS - Data Transformation Services - in its new release of SQL Server 2000...

Search

Code Samples

New Members