Trigger Enhancements
Triggers are not new to SQL Server, but they have found their way into the list of updates in SQL Server 2000. SQL developers have been using triggers for years to automate and control activity against tables. SQL Server 2000 adds enhancements to the AFTER trigger the only trigger mode in previous SQL Server versions and offers a new trigger mode, the INSTEAD OF trigger. INSTEAD OF triggers can be defined for each of the data manipulation actions UPDATE, DELETE, and INSERT and can be created on...
FAQs Udq
Q I have to introduce the concept of data warehousing into my organization. I'm concerned about the complexity, cost, and amount of time it will take to do this. How can I go about this task without biting off more than I can chew A If you have no data-warehousing facilities in place yet, consider introducing a data mart for a single department first. Because this operates on a smaller scale, it will be quicker, cheaper, and less difficult to get up and running. Later you can add data marts for...
Partitioning Your Data
Once you have decided on the criteria that you need for data portioning for example, locality or department , a unique CHECK Constraint range on the primary key field in each table on each server must be set to enforce the ranges of data you want each server to own. The key ranges of the CHECK constraints, on each table in a partitioned view, cannot overlap with the ranges of any other table used. Any given value of the partitioning column must map to only one table on each server. The CHECK...
Northwind
The Northwind database, the second of the two sample databases that are included with SQL Server, is modeled after a fictitious company that provides sales data for importing and exporting specialty foods. This popular sample database is commonly used by Microsoft and others. This book also uses the Northwind database throughout its examples. As you can with the Pubs database, you can browse Northwind's table, view, and stored procedures and modify it to examine additional functionality in SQL...
Introduction Uvt
Transferring and manipulating data was once the job of trained database administrators. With data the driving factor in markets that require reaction time in terms of minutes, having the information available to analyze is the key to making informed and accurate decisions for your organization. Getting data in and out of SQL Server is a common task, and several tools are available in SQL Server 2000 to accomplish this task. Whether it's importing data from heterogeneous systems such other...
Using the BulkCopy Object
In order to use the BulkCopy object with Visual Basic, you must access the Microsoft SQLDMO Object Library. You can access it using late binding with the CreateObject syntax, like this Set objSQLServer2 Or you can early bind to it by creating a reference to sqldmo.dll. It will appear as the Microsoft SQLDMO Object Library in the References list. Early binding provides significantly better performance and simplifies new development with the availability of Intellisense. Once you have made a...