Atlanta Custom Software Development 

   Search        Code/Page

User Login



Forgot the Password?
» Web Development
» Maintenance
» Data Integration/BI
» Information Management
VB VB (1648) (736)
C# C# (15) (779)
ASP ASP (41)
VC++ VC++ (25)
JScript JScript (5)
» SQL Server (708)
» ORACLE (5)
» MySQL (0)
» DB2 (0)
» C/C++/ASM (11)
» Microcontroller (1)
» Circuit Design (0)
» Networking (5)
» Unix/Linux (1)
» WinNT/2k/2003 (8)
» Flash (0)
» Maya (0)
» 3D max (0)
» Photoshop (0)
» (2)
» PC Interfacing (1)
» Networking (4)
» SQL Server (4)
» VB (23)
» (4)
» VC (3)
» HTML/CSS/JavaScript (10)
» Regular Expr Tester
» Free Tools


How to transfer database diagrams to a different database?
Total Hit (2549) Database diagrams are stored in the 'dtproperties' table within the database. So, database diagrams can be transferred to a different database, by transferring the contents of this table. For example , run the following query to transfer the diagram named 'MyTableDesign' from 'pubs' database to ' ....Read More
This is a link to a different site How do I convert from Access to SQL Server?
Total Hit (1030) The Access to SQL Server upsizing wizard is the best way to start. There's a different version for each version of Access.
This is a link to a different site Using Microsoft SQL Server Constraints
Total Hit (1234) In this article, I want to tell you about SQL Server constraints: what a constraint is, when it is used and for which purposes. You can find in this article some examples of constraint creation and SQL Server 2000 constraints enhancements.
This is a link to a different site Choosing SQL Server 2000 Data Types
Total Hit (969) Choosing an appropriate data type is very important, because the errors made in a table design can result in large performance degradation. These problems often surface later, when a large amount of data is inserted. In this article, I want to tell you about built-in and user-defined data types, how ....Read More
This is a link to a different site SQL Server 2000 Administration in 15 Minutes a Week: Database Creation Basics
Total Hit (944) Welcome to the fifth article in my series SQL Server Administration in 15 Minutes a Week. Last week we took a look at the SQL Server Enterprise Manager. We learned how to register our SQL Servers, how to organize Servers into groups, and we learned about the databases that are installed by default. ....Read More
This is a link to a different site Disabling or Enabling All Constraints of a Table or Database
Total Hit (1155) These procedures are very important to use when you need to load a bulk of data that you know is correct but when you do not need the foreign keys and check constraints to interfere while you are loading the data. This is also the case when you want to change key values and don't want the constraint ....Read More
This is a link to a different site Single Database or Multiple Databases
Total Hit (1288) Which is the way to better performance with Microsoft SQL Server 7.0: using a single database with lots and lots of tables or logically grouping data into multiple databases each with a significantly fewer number of tables? The system is comprised of one server with two hard drives that are mirrored ....Read More
This is a link to a different site Introduction to Relational Databases - Part 1: Theoretical Foundation
Total Hit (2134) Good introduction on general database theory and design. Lots of terminology (Entity, Attibute, Normalization ...) defined, explained of all...DEMONSTRATED!

Recommanded Links


Home   |  Comment   |  Contact Us   |  Privacy Policy   |  Terms & Conditions   |  BlogsZappySys

© 2008 BinaryWorld LLC. All rights reserved.