 |
Powerful New T-SQL Syntax Gives SQL Server a Programmability Boost
|
| Total Hit (2386) |
The T-SQL language in the upcoming version of SQL Server will provide more power and flexibility than previous versions. Additions and enhancements include error handling with the TRY/CATCH construct, SNAPSHOT isolation, and WAITFOR enhancements. Also important are the BULK rowset provider, common t
....Read More |
Rating
 |
|
|
|
|
|
|
|
|
|
Overview of Native XML Web Services for Microsoft SQL Server 2005
|
| Total Hit (1085) |
Get an overview of how to set up and use XML Web Services using SOAP/HTTP inside SQL Server 2005 (formerly known as "Yukon"). Illustrative examples are included. To get the most from this paper, you should have a basic understanding of Web service technologies including HTTP, SOAP, and WSDL.
....Read More |
| Rating
|
|
|
|
|
|
|
|
SQL Server "Yukon" Beta 1 Transact-SQL Enhancements
|
| Total Hit (943) |
This white paper introduces several of the new enhancements to Transact-SQL in Microsoft SQL Server "Yukon" Beta 1. These new features can increase your expressive power, the performance of your queries, and your error management capabilities. This paper focuses mainly on relational enhancements tha
....Read More |
| Rating
|
|
|
|
|
|
Managed UDTs Let You Extend the SQL Server Type System
|
| Total Hit (1007) |
The next version of SQL Server, code-named "Yukon," will offer enhanced support for user-defined types (UDTs). Because UDTs can be managed by the CLR, you can represent a wide variety of data structures to create types not possible with previous versions of SQL Server. With UDTs you can more precise
....Read More |
| Rating
|
|
|
|
XML, T-SQL, and the CLR Create a New World of Database Programming
|
| Total Hit (974) |
The next version of SQL Server, code-named "Yukon," includes quite a few enhancements and expanded language support. For example, Transact-SQL now conforms more closely to the ANSI-99 SQL specification and makes querying more flexible and expressive. Yukon can execute user-defined functions, stored
....Read More |
| Rating
|
|
|
|
New Version Showcases Native XML Type and Advanced Data Handling
|
| Total Hit (1169) |
The next version of Microsoft SQL Server, code-named "Yukon," represents quite a few steps forward in the evolution of XML integration. Yukon supports native storage of XML data using the XML data type, which makes it possible to run native queries on XML data using the emerging industry standard XQ
....Read More |
| Rating
|
|
|
|
Learning SQL Server 2005
|
| Total Hit (1001) |
Everyone wants to get ahead of the curve with SQL Server 2005, but many people don't have the time or desire to dig through a Google search. Steve Jones has gotten quite a few requests for resources, so here is a compiled list of some places that might help you get started.
....Read More |
| Rating
|
|
|
|
Encrypt and Decrypt Data in Yukon
|
| Total Hit (1067) |
Reports of more than 2 million credit card numbers stolen from merchants and data brokers in early 2005 brought about the expected knee-jerk reaction from federal lawmakers— new legislation that proposes to protect individuals against identity theft, such as the "Comprehensive Identity Theft Protect
....Read More |
| Rating
|
|
|
|
Comparing Oracle 10g and SQL Server Yukon
|
| Total Hit (1221) |
The purpose of the following technical paper from WisdomForce is to provide a feature comparison between MSSQL 2005 (Yukon) and Oracle 10g.
The document compares VLDB/OLTP related features and discuss issues with performance, utilities and replication. It discusses several new features, which we
....Read More |
| Rating
|
|
|
|
Querying the SQL Server System Catalog FAQ
|
| Total Hit (1121) |
Data Types
How do I find the data types of the columns of a specified table?
How do I find the LOB data types of a specified table?
How do I find the columns that depend on a specified data type?
How do I find the computed columns that depend on a specified CLR user-defined type or alias d
....Read More |
| Rating
|
|