Author: SSWUG Research

Community

Dynamic ORDER BY

From SQL Team……We've got another article chock full of SQL goodness from Garth. This one covers creating a dynamic ORDER BY clause for your SELECT statements. It's a follow up to his earlier article on dynamic WHERE clauses.

Community

XML Instance

XML Instance is a schema-driven data editor with which you can create, edit, and manage data-oriented XML documents, messages, and configuration files — including XSLT, XSDL and SOX documents. Use XML Instance to edit and validate XML business documents that conform to a DTD or XML schema in any pr

Community

The Paradox of Simplicity

By Brian Moran…Greetings, I'm amazed at the volume of responses I received from last week's commentary, which asked you to help "SQL Server newbies" take their careers and skill sets to the next level. I received dozens of letters in just a few days, and during the next few weeks,

Community

What is AuthXML?

AuthXML is a specification for authentication and authorization information in XML. AuthXML is a transport-independent XML definition that allows security authorities in separate organizations to communicate about authentication, authorization, user profiles and authenticated user sessions in an ope

Community

Transact-SQL

This article written by Rob Taylor talks about Transact SQL, also called T-SQL, is Microsoft's extension to the ANSI SQL language. It is the driving force of Microsoft's SQL Server and is a dynamic database programming language. There have been several extensions added to the ANSI SQL langua