Collaboration Data Objects
Home > SQL Server Definitions - Collaboration Data Objects
SearchSQLServer.com Definitions (Powered by WhatIs.com)
EMAIL THIS
LOOK UP TECH TERMS Powered by: WhatIs.com
Search listings for thousands of IT terms:
Browse tech terms alphabetically:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

Collaboration Data Objects


Show me everything on SQL/Transact SQL (T-SQL)

DEFINITION - Collaboration Data Objects (CDO) is Microsoft's technology for building messaging or collaboration applications or adding these capabilities to existing applications. Part of the Microsoft Exchange Server product, CDO has evolved from what Microsoft formerly called Object Linking and Embedding Messaging and, more recently, Active Messaging. Using Active Server Page (ASP) technology with CDO, a Web site builder can, for example, write a script that will exchange e-mail with users or with other Web sites, collaborate in discussions on other Web sites, or allow employees to schedule meetings with multiple recipients, review existing appointments, schedule new events, and so forth.

CDO is really an additional scripting interface to an existing Microsoft messaging model, the Messaging Application Programming Interface (MAPI). Collaborative Data Objects are made available through two CDO libraries. These libraries let you address programmable messaging objects (including folders, messages, recipient addresses, attachments, and other messaging components). These objects are extensions to the programmable objects, such as forms and controls, that are offered as part of Microsoft's Visual Basic program development environment.

Learn more about SQL/Transact SQL (T-SQL)
Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005: Learn how data is stored within DATETIME and SMALLDATETIME and get an overview of the TIMESTAMP data type -- as it's often confused with these two primary date/time data types.
SQL Server data conversions from date/time values to character types: Learn two built-in functions for SQL Server data conversion from T-SQL date/time values to character types. These methods include SQL Server CAST and CONVERT.
How to use rank function in SQL Server 2005: With ranking functions in SQL Server 2005, you can rank rows in result sets. This tip defines rank functions and gives examples of how to use the four available functions.
Exception handling best practices in SQL Server 2005: SQL Server 2005 brings you TRY/CATCH, a new T-SQL feature that helps find and address errors before they reach application code. Get best practices for working with it.
Create DDL table in SQL Server 2005 to audit DDL trigger activity: Create DDL table in SQL Server 2005 to audit Data Definition Language (DDL) trigger events when DML statements run. Define DDL trigger to track SQL changes.
Using the OUTPUT clause for practical SQL Server applications: Learn how using the OUTPUT clause in SQL Server 2005 queries simplifies T-SQL code and returns results of rows changed by an INSERT, UPDATE or DELETE SQL command.
Optimize T-SQL data types in SQL Server: To optimize Transact SQL (T-SQL) data types in SQL Server, learn how each type affects performance -- I/O, RAM and CPU in SQL Server.
Top 10 T-SQL tips for improved SQL Server development: Find out how to script SQL Server backups, why T-SQL in SSIS has pros and cons and what to do about poorly written T-SQL code that's causing SQL Server performance problems.
T-SQL error handling with Try…Catch blocks: T-SQL Try…Catch block for SQL Server exception handling has new, improved functions to handle errors when executing T-SQL code in SQL Server 2005.
T-SQL performance problems and solutions: Not all SQL Server performance problems are database-related. Poorly written T-SQL code could be to blame. Identify query problems and then get the workarounds in this clinic.
T-SQL commands vs. XML AUTO in SQL Server: XML functions may use more resources than standard T-SQL commands. Here are some performance implications when comparing XML AUTO with T-SQL commands.
Top 10 SQL Server development questions: SQL Server development can put you in a crunch. Get solutions here when it comes to concurrency problems, stored procedure results and writing T-SQL.
Top 10 SQL Server development tips of 2008: From converting date/time values into character types to retrieving XML data values with XQuery, these were the top 10 SQL Server development topics of 2008.
Additional T-SQL operations in SQL Server 2008: Learn how scalar operators, global variables and NULL values can be utilized in Transact-SQL in SQL Server 2008 in this book excerpt.
SQL Server 2008 function types in T-SQL: Functions in Transact-SQL can be either aggregate functions or scalar functions. This excerpt from "Microsoft SQL Server 2008: A Beginner's Guide" describes both.
Using T-SQL data types in SQL Server 2008: Learn the numerous data types used in SQL Server 2008's Transact-SQL language in this excerpt from "Microsoft SQL Server 2008: A Beginner's Guide."
Basic objects of T-SQL in SQL Server 2008: Discover the basic objects that drive T-SQL in SQL Server 2008 in this excerpt from "Microsoft SQL Server 2008: A Beginner's Guide."

CONTRIBUTORS: Pramod Anchuparayil
LAST UPDATED: 07 Jul 2009

Do you have something to add to this definition? Let us know.
Send your comments to techterms@whatis.com

More resources from around the web:
- Microsoft provides more information about Collaboration Data Objects.
- SearchVB.com, a portal for Visual Basic developers, includes a collection of links about Collaboration Data Objects.





FILE EXTENSION AND FILE FORMAT LIST
File Extension and File Format List:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #


RELATED CONTENT
Using DELETE and TRUNCATE TABLE statements to delete data in SQL Server
Both statements can be used to delete SQL Server data, but some situations call for one over the other.
SQL language crash course (just enough to be dangerous)
You can't get far in the SQL Server world if you don't speak the language. Check out the basics of SQL language with examples of common SQL Server...
Working with IntelliSense in SQL Server 2008 Management Studio
IntelliSense in SQL Server 2008 Management Studio provides easy access to language elements when writing T-SQL queries. Knowing the basics can...

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
ACID  (SearchSQLServer.com)
commit  (SearchSQLServer.com)




Collaboration Data Objects Solutions - SQL White Paper Library
HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts