SQL Tutorial - Free Templates - Free Cpanel Hosting


Using Triggers to track database action history Tal Kelley demonstrates how to use triggers in SQL Server in order to keep track of who is modifying your database tables
http://www.developerfusion.com/show/2413/			Hits:23
Your First SQL Server 2000 Database Curious about SQL Server 2000? Learn how to create databases in Enterprise Manager and Query Analyser today
http://webmasterbase.com/article/722			Hits:23
How to Troubleshoot SQL Server 7.0 Installation Issues Find out how to troubleshoot failed SQL Server 7.0 installations
http://www.sql-server-performance.com/ac_sql_server_install_7.asp			Hits:22

Picking a Random Record Using a Stored Procedure There are a number of articles here on 4Guys and ASPFAQs.com that examine how to return a random record from a database table. One approach is to use a stored procedure that builds a temporary table in order to remove the gaps between a column's identity
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=173			Hits:22
Learn SQL Server 2000 in 15 Minutes a Week: Intro to SQL and T-SQL Mike Aubert's latest article in the Learning SQL Server Administration in 15 Minutes a Week series focuses on introducing the reader to Structured Query Language, or SQL, and also covers T-SQL and transaction logs
http://www.swynk.com/friends/maubert/70-228-6-1.asp			Hits:21
Scalability and High Availability of Microsoft SQL Server 2000 INSERT INTO `sites` VALUES(Part 2) SQL Server 2000 is tightly integrated with the clustering software. For example, SQL Server service can be stopped from SQL Administrative tools INSERT INTO `sites` VALUES(like Enterprise Manager or Service Manager); rather than from the Cluster Administrator. The best example of
http://www.databasejournal.com/features/mssql/article.php/1690901			Hits:21
Stored Procedures in SQL Server Stored procedures offer great performance, security and abstraction benefits to SQL Server developers
http://www.databases.about.com/library/weekly/aa042201a.htm			Hits:21

The sql_variant Datatype Microsoft introduced the sql_variant in SQL Server 2000. You can use the sql_variant to store data of an unspecified or inconsistant type. Or to store data of almost any SQL Server datatype
http://www.sqlteam.com/item.asp?ItemID=7881			Hits:21
Why do I get a closed recordset from my stored procedure? If you have tried to work through the resulting Recordset, you may have difficulties. This is due to how SQL Server and ADO work together when using stored procedures with multiple SQL statements. To learn how to fix this, and to allow for multiple SQL s..
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=174			Hits:21
Compare SQL Server Databases with sp_CompareDB I bet almost every DBA has at times desperately wanted to be able to compare data and structure between database tables, or even whole databases for that matter. Wouldn�t it be nice to have a stored procedure that uses only two parameters -- the name of ..
http://www.sql-server-performance.com/vg_database_comparison_sp.asp			Hits:20
Page:1 2 3 4 5 6 7