MS-SQL-Examples w/free code & more

Steve Schofield

• Step by Step instructions to schedule a stored procedure to run over and over! I was working on a project in
  ms sql 7 and needed to know how to get a stored procedure to be reoccurring. Click here to find out
  how
• Using ASP, SQL Server
  6.5/7.0 & Stored Procedures–Adding records and returning the IDENTITY VALUE writing
  out to the ASP page! (A how-to I found useful).(FREE code
  which includes, stored procedure code, sql scripts & webpages!!
  
• Using ASP to write records
  & retrieve ALL DATA including the (“Identity field”) back from Sql Server
  using stored procedures.

• Sample of how to Create
  Records w/Unique ID # without using IDENTITY Datatype.
  Sometimes there is a problem using the IDENTITY datatype in Sql Server.  This example
  uses Sql Server, Active Server Pages & Stored Procedures.  This is an alternative
  but your inserted record will still have a Unique Record ID.

• Using the
  NEXTRECORDSET method of the RECORDSET OBJECT to parse out multiple SELECT statements from
  one connection to a database.

* Step by Step instructions to schedule a stored procedure to run over and over! I was working on a project in ms sql 7 and needed to know how to get a stored procedure to be reoccurring. Click here to find out how
*

Links other Misc. Stuff

• Download the upsizing
  wizard that allows MS Access to be ported to Sql Server
• Microsoft Sql Server Homepage – Evaluation
  copies, information and more!!! 1st place to start on Sql Server
• MSSqlServer.com – an independent site that has
  nice stuff on Sql Server

Newsgroups for MS-SQL Server

• SQL Server
  Clients
  (microsoft.public.sqlserver.clients)
• SQL Server
  Connections
  (microsoft.public.sqlserver.connect)
• SQL
  Server Data Warehouse
  (microsoft.public.sqlserver.datawarehouse)
• SQL Server ODBC
  (microsoft.public.sqlserver.odbc)
• SQL Server
  Programming
  (microsoft.public.sqlserver.programming)
• SQL Server
  Replication
  (microsoft.public.sqlserver.replication)
• SQL Server Server
  (microsoft.public.sqlserver.server)
• SQL Server Setup
  (microsoft.public.sqlserver.setup)
• Usage Analyst
  (microsoft.public.usageanalyst)