Simon Fraser University

SQL Procedure Pass-Through Facility

The SQL Procedure Pass-Through Facility is an extension of the SQL procedure that enables you to send DBMS-specific statements to a DBMS and to retrieve DBMS data. You specify DBMS SQL syntax instead ...
Simon Fraser University

Naming Examples

In this example, you create a simple table to test for yourself how the options work. To use name literals, you must specify the SAS system option VALIDVARNAME=ANY. Notice that you print the new DBMS ...
Ars Technica

SQL SSMS stored proc syntax validation

We have a server with full text searching enabled and another where it is not. We have a stored proc that checks if full text indexing is enabled and runs a search query as appropriate but the issue ...
Ars Technica

SQL Server - What is optimal RAID configuration? And SQL multi-proc licensing?

Looking to run SQL 2000 as a platform for an ERP app on a new box. Dual P4, 2GB RAM, up to 6 SCSI drives in any of a variety of RAID configurations.<BR><BR>The research I've done and the ERP vendor ...
Houston Chronicle

Stored Procedures Vs. Prepared Statements in PHP and MySQL

The PHP development language provides you with a "prepare" function to send a prepared statement to a SQL database. You can use full, inline SQL statements in the prepared statement function or send ...