Did you mean
Microsoft SQL Server Transact-SQL (50 results)
Sponsored White Papers, Webcasts, and Downloads
- sort by:
- Relevance
- Date
- Popularity
- Editing Transact-SQL Code in SQL Server 2005 Beta 2
- Management Studio is the primary tool for developing Transact-SQL queries in Microsoft SQL Server 2005 Beta 2. This paper introduces you to the Management Studio Transact-SQL editing facilities, highlighting some of its more interesting and compelling new features for Transact-SQL development. This paper explains how Management Studio differs from, and...
- White papers 2004-10-01
- Translating Procedural Statements Between Oracle and SQL Server
- This white paper is intended to give a QUICK but thorough overview of the issues database users may encounter when translating procedural code, such as stored procedures or user-defined functions, between Oracle's PL/SQL and Microsoft SQL Server's Transact-SQL procedural extensions to the ANSI SQL standard. The document should be equally...
- White papers 2003-02-12
- SwisSQL--SQL Server to Oracle Edition (exe)
- SwisSQL--SQL Server to Oracle Migration tool is an automated migration tool to convert stored procedures implemented in Microsoft SQL Server Transact SQL (T-SQL) into equivalent Oracle PL/SQL code. It automates more than 90% of T-SQL code conversion into PL/SQL. It provides productivity benefits by eliminating error prone manual effort. SwisSQL...
- Software downloads 2005-03-25
- Ubitsoft SQL Enlight (zip)
- Ubitsoft SQL Enlight is a software development tool targeted to database professionals who need to write, read and analyze Transact-SQL scripts. Ubitsoft SQL Enlight integrates with MS SQL Server 2005 Management Studio and MS Visual Studio 2005.Key features:reformat T-SQL code with set of customizable rules; summarize T-SQL script;T-SQL statements outlining;validate...
- Software downloads 2007-12-21
- SQL Building Blocks and Server Settings
- This hefty (200-page) chapter, taken from the comprehensive Transact-SQL Desk Reference: For Microsoft SQL Server, looks at the building blocks that database designers and users have available for creating and modifying database objects and data. The well-organized information and liberal use of examples make this a terrific resource to use...
- Book chapters 2005-03-29
- What's New for XML in SQL Server 2008
- Microsoft introduced XML-related capabilities in Microsoft SQL Server 2000 with the FOR XML and OPENXML Transact-SQL keywords, which enabled developers to write Transact-SQL code to retrieve a query result as a stream of XML, and to shred an XML document into a rowset. SQL Server 2008 builds on the XML...
- White papers 2008-08-01
- SQL Building Blocks and Server Settings
- This hefty (200-page) chapter, taken from the comprehensive Transact-SQL Desk Reference: For Microsoft SQL Server, looks at the building blocks that database designers and users have available for creating and modifying database objects and data. The well-organized information and liberal use of examples makes this a terrific resource to use...
- Download resources 2005-03-29
- SQL Server Survival Guide for Network Administrators
- Microsoft's SQL Server can be a scary place, especially if you don't have much database experience. So we put together this resource to help guide you through some of the basic SQL functions. We divided it into two sections: SQL Server Basics covers common tasks you may be called upon...
- Download resources 2005-01-05
- SQL Server Survival Guide for Net Admins PDF
- This resource will guide you through some of the basic SQL functions. We divided it into two sections: SQL Server Basics covers common tasks you may be called upon to perform; Transact-SQL Reference introduces the fundamentals of T-SQL code and query building to help you find information in your database....
- Download resources 2004-10-07
- MSDN Webcast: geekSpeak: T-SQL Tips and Tricks in SQL Server 2008 With Andrew Karcher (Level 200)
- This webcast is for Transact-SQL (T-SQL) lover. The presenter introduces to several new features of SQL Server 2008, including the hierarchy ID data type, the FileStream object, table-valued parameters, and large user-defined types.
- Webcasts 2008-06-04
- Microsoft T-SQL Performance Tuning Part 2: Analyzing and Optimizing T-SQL Query Performance on Microsoft SQL Server Using Indexing Strategies
- This paper describes a variety of performance tuning techniques that you can apply to your Microsoft SQL Server Transact-SQL programs. In many cases, you could use the graphic user interface provided in Microsoft SQL Enterprise Manager or Microsoft SQL Query Analyzer to achieve the same or similar results to those...
- White papers 2005-01-01
- TranslateSQL (zip)
- TranslateSQL is a utility for converting an Oracle schema into an SQL build script for SQL-Server. Unlike the import wizard that comes with SQL-Server, it actually converts all the indexes, primary keys, foreign constraints, and check constraints. However, it does not copy the data in each of the tables, nor...
- Software downloads 2004-10-07
- MSDN Webcast: SQL Server 2005 Masterclass: The New Features of T-SQL in SQL Server 2005 (Level 300)
- The demands on databases keep increasing-demands to use them in new ways, and demands to sort across new relationships. Wouldn't it be nice if something came along to make database development easier? Something has come along: Transact-SQL (T-SQL) in Microsoft SQL Server 2005.This webcast describes the new features of T-SQL...
- Webcasts
- Transact-SQL Cookbook: Statistics in SQL
- In spite of the fact that the user can use SQL to generate statistics, it is not the papers intention to promote SQL as the best language for that purpose. As in any other situation, a strong dose of common sense is necessary. If the user needs a fast, easy-to-use...
- Book chapters 2002-03-01
- Extending SQL Server Reporting Services With SQL CLR Table-Valued Functions
- A new feature of Microsoft SQL Server 2005 is its integration with the Microsoft .NET Framework common language runtime CLR. This allows .NET Framework classes and functions to be incorporated into Transact-SQL statements and queries. This white paper describes how to take advantage of SQL CLR table-valued functions to combine...
- White papers 2007-02-01
- MSDN Webcast: SQL Server 2005 Essentials (Part 02 of 14): Using .NET Procedural Code in SQL Server 2005 (Level 200)
- One of the most exciting features in Microsoft SQL Server 2005 from a developer's point of view is the ability to write procedural SQL Server code in any managed language. This webcast covers in detail how to write procedures, functions, and triggers using a managed language and discusses when to...
- Webcasts
- Recovery for SQL Server (exe)
- Recovery for SQL Server recovers damaged Microsoft SQL Server database files (.MDF/.NDF). It creates Transact-SQL script that re-creates the database from the scratch. Recovery for SQL Server is able to recover corrupted tables, views, stored procedures, and triggers. Both standard and user-defined data types recovery is supported. Also repairs damaged...
- Software downloads 2006-10-25
- Using CLR Integration in SQL Server 2005
- This paper describes how database application developers and architects can take advantage of the CLR integration features in SQL Server 2005. It compares CLR-based programming with existing programming models supported in SQL Server, such as Transact-SQL and extended stored procedures, and highlights the relative strengths and weaknesses of each. It...
- White papers 2004-11-01
- MSDN Webcast: SQL Server 2005 Essentials (Part 03 of 14): The SqlServer Data Provider (Level 200)
- As a person writes code to run in-process in Microsoft SQL Server 2005, he also needs a provider that runs in the same process space as SQL Server. This webcast covers the new provider, System.Data.SqlServer, and discusses how connections, variable mappings, and other functions built into Transact-SQL are handled when...
- Webcasts
- MSDN Webcast: Using Transact-SQL for Recursive Queries in SQL Server 2005 (Level 300)
- Microsoft SQL Server 2005 is the first version of SQL Server that supports recursive queries and implementing a standard recursive Common Table Expression CTE. This webcast explores recursive CTEs and demonstrates how to use them to answer common requests against graph structures. Using an employee organizational chart as an example...
- Webcasts
- << Previous
- page 1 of 5
- Next >>
