XML in SQL Server
Home > SQL Server Topics > SQL Server Development > XML in SQL Server > Reference & Learning
SQL Server Topics:
EMAIL THIS
 TOPICS HOME   BROWSE ALL SQL SERVER TOPICS   SQL SERVER INFO CENTERS   RESOURCE CENTERS     RSS FEEDS 

XML in SQL Server

IN THIS TOPIC:  EXPERT TECHNICAL ADVICE (19) , REFERENCE & LEARNING (20) , NEWS (1) , BEST WEB LINKS (2) , DEFINITIONS (3)

Display in sets of:

  1 - 10 of 20 in Reference & Learning << Previous   page 1 2   Next >>

Problems and justified use of cursors
McGraw-Hill | 07 Feb 2007
TUTORIAL - Cursors should traditionally be avoided, however, this book excerpt outlines situations in which cursors are acceptable in T-SQL.
Cursor related statements
McGraw-Hill | 07 Feb 2007
TUTORIAL - This book excerpt illustrates cursor statements, including the open statement, fetch statement, @@fetch_status, close statement and the deallocate statement for T-SQL cursors.
Transact SQL cursors
McGraw-Hill | 07 Feb 2007
TUTORIAL - The following excerpt outlines how to process a cursor for Transact-SQL Server. You'll also find an example of how cursors are used to repeat custom processing.
Unconditional and scheduled execution
McGraw-Hill | 07 Feb 2007
TUTORIAL - This book excerpt explains unconditional execution and scheduled execution for flow control statements in T-SQL.
Blocks, looping and conditional flow control statements
McGraw-Hill | 07 Feb 2007
TUTORIAL - This book excerpt further explains flow-control statements, including statement blocks, conditional execution and looping.
Flow control statements
McGraw-Hill | 07 Feb 2007
TUTORIAL - Flow-control statements from T-SQL lack user friendliness, yet they allow for complex procedures. Learn the benefits of using comments in T-SQL programming constructs.
Table variables
McGraw-Hill | 07 Feb 2007
TUTORIAL - Get explanations and examples, in this chapter excerpt, for declaring table variables when working with T-SQL constructs.
Global variables
McGraw-Hill | 07 Feb 2007
TUTORIAL - This book excerpt on basic T-SQL programming constructs explains and gives examples of global variables.
Local variables
McGraw-Hill | 07 Feb 2007
TUTORIAL - In this book excerpt, find operations such as declaring variables, assigning values with the select, set, or update statement; and displaying values when using T-SQL.
Special data types-Part 2
McGraw-Hill | 07 Feb 2007
TUTORIAL - This section continues discussion of special data types, including table and the cursor types and also traditional user-defined data types.


  1 - 10 of 20 in Reference & Learning << Previous   page 1 2   Next >>

HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




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