SQL Server Magazine

Rem, August 2006

This month, Rem answers a question about the various ways to build T-SQL statements in SQL Server 2005 and Visual Studio 2005.

Creating T-SQL Statements in SQL Server 2005 and Visual Studio 2005

SQL Server 2005 and Visual Studio 2005 provide query-building interfaces for creating, editing, and testing T-SQL statements that access data in a SQL Server database.

Using XQuery Expressions to Create Computed Columns

To create a computed column in SQL Server 2005, you can use an XQuery expression, but you must invoke an XML data type method. However, SQL Server doesn’t allow XML methods in computed-column definitions. Here’s how to get around this conundrum.

Logging DDL Events

The simplest way to log DDL events is to take advantage of the new DDL trigger feature in SQL Server 2005. You can create triggers that fire when specified DDL events occur, such as modifying column definitions or dropping login accounts.

Rem

This month, Rem answers questions about the simplest way to log DDL events in SQL Server 2005 and what improvements Microsoft made to ASP.NET client-side scripting with the release of Windows .NET Framework 2.0.

Rem

Rem: Obtaining Data from a SQL Server Database

A VBScript script can help you obtain data from a SQL Server database.

Rem: Character Separators for Multiple Logon Scripts

You can use the Call command to run multiple logon scripts per user.