|
|
|
|
| |
Introduction
How many times have you started to create a batch of SQL, gotten half-way through, and then realized that something you've just spent the better part of 3 hours on could've been completed using one of SQL Server 2000's built-in procedures?
In this article I'm going to show you ten extended stored procedures that are available to us through code in Microsoft SQL Server 2000. Extended stored procedures are created and loaded using DLL's (which are created in C/C++), and offer more independent functionality than standard procedures (such as access to the Win32 API, services, direct disk/network access, etc), and because they're compiled externally as dynamic linking libraries (DLL's), they're also quicker.
To test the extended procedures in this article you should have Microsoft SQL Server 2000 installed on your Windows 2000 box. You should login to SQL Server using an administrator's account. If you don't have Microsoft SQL Server 2000, you can download a free 120-day evaluation copy here.
Read More... |
|
|
|
| Executing SQL Server Stored Procedures With PHP
Categories : PHP, Databases, MS SQL Server | | | Creating User Defined Functions In SQL Server 2000
Categories : Databases, MS SQL Server | | | Simple Connection to mSQL with PHP
Categories : PHP, mSQL, Databases | | | Backing Up Your MySQL Databases With MySQLDump
Categories : MySQL, Databases | | | Custom MySQL-functions
Categories : Databases, MySQL, PHP, PHP Functions | | | Saving Images in MySQL
Categories : MySQL, PHP, Graphics, Databases | | | Database Abstraction with PEAR
Categories : PHP, Pear, Databases | | | Simple Connection to Oracle with PHP
Categories : PHP, Oracle, Databases | | | Watching The Web
Categories : PHP, Databases, MySQL, HTTP, MD5 | | | How To add paging (Pagination) with PHP and MySQL
Categories : PHP, Beginner Guides, Databases, MySQL, HTML and PHP | | | SQL In Simple English Part 2 of 2
Categories : Databases, General SQL | | | Referer Statistics
Categories : PHP, MySQL, HTTP, Databases | | | PHP 101 Part 8 of 15 : Databases and Other Animals
Categories : PHP, Beginner Guides, Databases | | | Simple Connection to PostgreSQL with PHP
Categories : PHP, PostgreSQL, Databases | | | Introduction to using PHP 5.0 and SQLite
Categories : PHP, SQLite, Databases | |
| | |
|
|
