TWCN Tech News

How to create SQL Stored Procedures via SQL Server

SQL Server is one of the best products to come out of Microsoft, but not every professional knows how to use it effectively. For example, some might find it difficult to create a stored procedure but ...
Simon Fraser University

SQL Procedure Pass-Through Facility

Beginning in Version 7 of SAS/ACCESS software, there are a number of changes in the way the SQL Procedure Pass-Through Facility works. For more information, see SQL Procedure Pass-Through Facility ...
Ars Technica

Any alternative to recursive sql stored procedure?

I'm having an issue with an ASP page occasionally timing out. The specific error is the following:<BR><BR>"*.DBCommand.Execute(): Microsoft OLE DB Provider for SQL ...
Simon Fraser University

Reading and Updating Data with the SQL Procedure

In Version 6, the SAS System's SQL procedure enabled you to retrieve and update data from DBMS tables and views. You could read and display DBMS data by specifying a ...
Ars Technica

SQL Server 2000, Stored Procedures and file counting...

I'm looking for information on writing a stored procedure that can count files in a directory and return a resultset to perform various jobs on depending on a count.<BR><BR>For instance, let's say the ...