Get started
Bring yourself up to speed with our introductory content.
SQL Transact SQL T SQL
Special data types-Part 2
This section continues discussion of special data types, including table and the cursor types and also traditional user-defined data types.Continue Reading
Cursor related statements
This book excerpt illustrates cursor statements, including the open statement, fetch statement, @@fetch_status, close statement and the deallocate statement for T-SQL cursors.Continue Reading
Special data types-Part 1
In book excerpt, special data types are defined, including: timestamp, uniqueidentifier, and cursor and xml data types, a major new feature in SQL Server 2005. User defined data types are also explained, which can be defined in Transact-SQL or .NET.Continue Reading
-
Transact SQL cursors
T-SQL cursors are used to repeat custom processing for each row of the cursor. The following excerpt outlines how to process a cursor for Transact-SQL Server and gives an example.Continue Reading
Date, time and number data types in SQL Server
In this book excerpt on basic T-SQL programming constructs, date and time, integer numbers, approximate numbers, exact numbers, monetary and binary data types are defined and examples given.Continue Reading
T-SQL Learning Guide
Transact-SQL (T-SQL) is no stranger to the SQL Server developer or DBA, but that's no excuse not to become more familiar. Improve your T-SQL skills with these T-SQL overviews, best practices and stored procedures.Continue Reading
ACID (atomicity, consistency, isolation, and durability)
ACID (atomicity, consistency, isolation, and durability) is an acronym and mnemonic device for learning and remembering the four primary attributes ensured to any transaction by a transaction manager (which is also called a transaction monitor).Continue Reading
OLE DB (OLEDB or Object Linking and Embedding Database)
OLE DB is Microsoft's strategic low-level application program interface (API) for access to different data sources.Continue Reading
T-SQL (Transact-SQL)
T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL) including transaction control, exception and error handling, row processing, and declared variables.Continue Reading
SQL (Structured Query Language)
SQL (Structured Query Language) is a standard interactive and programming language for getting information from and updating a database.Continue Reading
-
commit
A commit is the final step in the successful completion of a previously started database change as part of handling a transaction in a computing system.Continue Reading
Collaboration Data Objects (CDO)
Collaboration Data Objects (CDO) is Microsoft's technology for building messaging or collaboration applications or adding these capabilities to existing applications.Continue Reading
container
In Sun Microsystems' JavaBeans component architecture and in Microsoft's Component Object Model (COM), a container is an application program or subsystem in which the program building block known as a component is run.Continue Reading
DAO (Data Access Objects)
DAO (Data Access Objects) is an application program interface (API) available with Microsoft's Visual Basic that lets a programmer request access to a Microsoft Access database.Continue Reading
query
A database query can be either a select query or an action query. A select query is simply a data retrieval query. An action query can ask for additional operations on the data, such as insertion, updating or deletion.Continue Reading