• Unconditional and scheduled execution

    Unconditional execution (the GoTo Statement) in T-SQL forces the server to continue the execution from a label within a stored procedure or batch. Scheduled execution (the WaitFor Statement) allows the developer to schedule a time for the remaining statements to be executed. Both are explained in...

    ITKE62,320 pointsBadges:
  • CLR stored procedures

    Stored procedures are one of the most common database objects that you'll want to create using one of the managed .NET languages. One of the best uses for CLR stored procedures is to replace existing extended stored procedures. Learn the best methods in this chapter excerpt.

    ITKE62,320 pointsBadges:
  • 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.

    ITKE62,320 pointsBadges:
  • User-Defined Functions

    Creating .NET-based user-defined functions (UDFs) is another new feature that's enabled by the integration of the .NET CLR. Learn more about them in this chapter excerpt.

    ITKE62,320 pointsBadges:
  • 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.

    ITKE62,320 pointsBadges:
  • 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.

    ITKE62,320 pointsBadges:
  • SQL Server tutorials

    SearchSQLServer.com's tutorials provide the in-depth information SQL Server database administrators and developers are seeking on Microsoft's flagship database enterprise server, SQL Server and its latest release SQL Server 2008. Our SQL Server tutorials address areas you need to know about,...

    ITKE62,320 pointsBadges:
  • CLR triggers

    In addition to stored procedures and user-defined functions, the new .NET integration capabilities found in SQL Server 2005 also provide the ability to create CLR triggers. Find out how in this chapter excerpt.

    ITKE62,320 pointsBadges:
  • 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.

    ITKE62,320 pointsBadges:
  • Learning Guide: SQL Server basics

    SQL Server is gaining ground in the database space. As more companies turn to the DBMS hyped as the low-cost big player, more DBAs will have to learn its intricacies. With that in mind, we created this learning guide, highlighting basic SQL Server information that can help Oracle and DB2 pros get...

    ITKE62,320 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.