1 Resources for

transact-sql desk reference

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

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...; Tags: building block, database, Microsoft SQL, Microsoft SQL Server, Microsoft SQL Server 2000, Microsoft SQL Server Transact-SQL, Prentice Hall Inc., server, Server Setting, Server Settings, SQL, SQL Building Blocks, tandem, Transact-SQL Desk Reference; Download resources 2005-03-29

Additional Resources

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...; Tags: Microsoft SQL Server, Server, SQL, Prentice Hall Inc., Microsoft Corp., Databases, Storage, Enterprise Software, Software, Data Management, Hardware; Book chapters 2005-03-29
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...; Tags: Microsoft SQL Server Transact-SQL, Microsoft SQL Server, Microsoft SQL Server 2005, Management Studio, Databases, Enterprise Software, Software, Data Management; White papers 2004-10-01
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...; Tags: Microsoft SQL Server Transact-SQL, TechRepublic Inc., Microsoft SQL Server, Server, Databases, Enterprise Software, Software, Data Management; 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....; Tags: Microsoft SQL Server Transact-SQL, Administrator, Adobe PDF, Microsoft SQL Server, Server, Databases, Enterprise Software, Software, Data Management; Download resources 2004-10-07

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...; Tags: Microsoft SQL Server Transact-SQL, Database Administrator, Oracle Corp., Microsoft SQL Server, PL/SQL, Server, Quest Software Inc., Databases, Programming Languages, Enterprise Software, Software, Data Management, Software Development, Software/Web Development; 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...; Tags: Microsoft SQL Server Transact-SQL, Oracle Corp., Microsoft SQL Server, Server, Tool, Databases, Enterprise Software, Software, Data Management; Software downloads 2005-03-25
SwisSQL--Sybase to Oracle Edition (exe): SwisSQL Sybase to Oracle Edition is an automated migration tool to convert stored procedures implemented in Sybase Adaptive Server Transact SQL into equivalent PL/ SQL code. It automates more than 90% of the Sybase Transact SQL code conversion into Oracle PL/SQL with very minimal manual intervention.Version 2.5 may include unspecified...; Tags: Microsoft SQL Server Transact-SQL, Oracle Corp., AdventNet Inc., Sybase Inc., Databases, Enterprise Software, Software, Data Management; Software downloads 2005-03-25
SwisSQL--Sybase to SQL Server (exe): SwisSQL--Sybase to SQL Server is an automated migration tool to convert stored procedures implemented in Sybase Adaptive Server Enterprise ASE Transact SQL code into equivalent SQL Server Transact SQL. It automates more than 95% of the Sybase TSQL code conversion with very minimal manual intervention. SwisSQL migration tool removes the...; Tags: Microsoft SQL Server, Sybase Adaptive Server Enterprise, Server, AdventNet Inc., Sybase Inc., SwisSQL Migration Tool, Databases, Enterprise Software, Software, Data Management; Software downloads 2005-07-26
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...; Tags: Microsoft SQL Server Transact-SQL, Ubitsoft SQL Enlight, Databases, Enterprise Software, Software, Data Management; Software downloads 2007-12-21
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.; Tags: Microsoft SQL Server Transact-SQL, Microsoft Developer Network, Microsoft SQL Server 2008, Webcast, Microsoft SQL Server, Databases, Enterprise Software, Software, Data Management; 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...; Tags: Microsoft SQL Server Transact-SQL, Performance, Microsoft SQL Server, Server, Microsoft Corp., Quest Software Inc., Performance Management, Databases, Human Resources, Workforce Management, Enterprise Software, Software, Data Management; White papers 2005-01-01
TimesTen/Transact: Real-Time Transaction Processing System: TimesTen/Transact Transact is a real-time transaction processing system. It provides an infrastructure upon which to build very high-speed transactional applications, such as those used in securities trading, telecom billing, and online commerce. Application developers can focus on their business logic and rely on Transact to integrate messaging, data management, transaction...; Tags: ICG Commerce Inc., Billing, Transaction Processing System, Data Management, Databases, Enterprise Software, Software; White papers 2005-02-10
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...; Tags: Source Code, Constraint, TranslateSQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; 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...; Tags: Microsoft SQL Server Transact-SQL, Microsoft Developer Network, Webcast, Microsoft SQL Server, Microsoft Corp., Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management; 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...; Tags: Microsoft SQL Server Transact-SQL, Statistics, SQL, O'Reilly Media Inc., Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; 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...; Tags: Microsoft .NET Framework, Microsoft SQL Server, Server, SQL, Microsoft Corp., .Net, Databases, Enterprise Software, Software Development, Software/Web Development, Software, Data Management; 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...; Tags: Microsoft Developer Network, Microsoft .NET, Webcast, Microsoft SQL Server, Microsoft Corp., Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management; 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...; Tags: Recovery, Microsoft SQL Server, Server, Databases, Enterprise Software, Software, Data Management; 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...; Tags: Microsoft SQL Server, Microsoft SQL Server 2005, CLR, Programming, Integration, .Net, Middleware, Development Tools, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; White papers 2004-11-01

<< Previous
page 1 of 1
Next >>

TechRepublic Power Checklist: Securing Windows XP: If you have just finished installing Windows XP and you think the work is done, you're wrong. Some of the most important steps to getting Windows XP u ...; Buy Now

TechRepublic's IT Hardware and Software Purchasing Policy: Your IT Budget is tight. You want to get the most bang for your IT buck. That's where the IT Hardware and Software Purchasing Policy can help. This p ...; Buy Now