Sql Server Notes

Only available on StudyMode
  • Topic: SQL, Data Definition Language, Database
  • Pages : 15 (3362 words )
  • Download(s) : 44
  • Published : April 17, 2011
Open Document
Text Preview
SQL Server 2000
Microsoft SQL Server 2000 is a set of components that work together to meet the data storage and analysis needs of the largest Web sites and enterprise data processing systems.

Features of SQL Server 2000

Internet Integration: The SQL Server 2000 database engine includes integrated XML support. It also has the scalability, availability, and security features required to operate as the data storage component of the largest Web sites. The SQL Server 2000 programming model is integrated with the Windows DNA architecture for developing Web applications, and SQL Server 2000 supports features such as English Query and the Microsoft Search Service to incorporate user-friendly queries and powerful search capabilities in Web applications.

Scalability and Availability: The same database engine can be used across platforms ranging from laptop computers running Microsoft Windows 98 through large, multiprocessor servers running Microsoft Windows 2000 Data Center Edition. SQL Server 2000 Enterprise Edition supports features such as federated servers, indexed views, and large memory support that allow it to scale to the performance levels required by the largest Web sites.

Enterprise-Level Database Features: The SQL Server 2000 relational database engine supports the features required to support demanding data processing environments. The database engine protects data integrity while minimizing the overhead of managing thousands of users concurrently modifying the database. SQL Server 2000 distributed queries allow you to reference data from multiple sources as if it were a part of a SQL Server 2000 database, while at the same time, the distributed transaction support protects the integrity of any updates of the distributed data. Replication allows you to also maintain multiple copies of data, while ensuring that the separate copies remain synchronized.

Ease of installation, deployment, and use: SQL Server 2000 includes a set of administrative and development tools that improve upon the process of installing, deploying, managing, and using SQL Server across several sites.

Data warehousing: SQL Server 2000 includes tools for extracting and analyzing summary data for online analytical processing. SQL Server also includes tools for visually designing databases and analyzing data using English-based questions.

Data Types
In Microsoft SQL Server, each column, local variable, expression, and parameter has a related data type, which is an attribute that specifies the type of data (integer, character, date & time, and so on) that the object can hold. SQL Server supplies a set of system data types that define all of the types of data that can be used with SQL Server. The set of system-supplied data types is shown below.

int, bigint, smallint, and tinyint
Exact number data types that use integer data.

Integer (whole number) data from -2^63 (-9223372036854775808) through 2^63-1 (9223372036854775807), Storage size is 8 bytes.

Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647), Storage size is 4 bytes. The SQL-92 synonym for int is integer.

Integer data from -2^15 (-32,768) through 2^15 - 1 (32,767), Storage size is 2 bytes

Integer data from 0 through 255, Storage size is 1 byte

Approximate Numerics

Floating precision number data from -1.79E + 308 through 1.79E + 308 real
Floating precision number data from -3.40E + 38 through 3.40E + 38

datetime and smalldatetime

Date and time data from January 1, 1753, through December 31, 9999, with an accuracy of three-hundredths of second or 3.33 milliseconds Storage size is 8 bytes

Date and time data from January 1, 1900, through June 6, 2079, with an accuracy of one minute, Storage size is 4 bytes

Character Strings
char(n) Fixed-length non-Unicode character data with length of n bytes. n must be a value from 1 through 8,000....
tracking img