Problem solve

SQL Transact SQL T SQL

• Using the OUTPUT clause for practical SQL Server applications

  The OUTPUT clause returns results of all the rows affected by an INSERT, UPDATE or DELETE command' has provides many options for simplifying your T-SQL code. In some scenarios, it can even eliminate the need for triggers. Learn how to use the OUTPUT... Continue Reading

• Create DDL table in SQL Server 2005 to audit DDL trigger activity

  Each time DDL statements in SQL Server 2005 make changes with commands, such as CREATE TABLE and ALTER, the DDL trigger fires an event. It's possible to log these events with an audit table and custom-made DDL trigger. In this tip, SQL Server expert... Continue Reading

• SQL Server source code analysis and management adds database security

  Manage and protect your SQL Server databases by implementing source code analysis. Source code is the foundation of any application, and integrating methods to test and debug this code adds a key layer of security. IT security specialist Kevin ... Continue Reading

• Retrieve XML data values with XQuery in SQL Server 2005

  When you want to access specific XML data values -- instead of XML as a single data type value -- the XQuery is the scripting language you're looking for. Microsoft designed XQuery specifically to access XML data in SQL Server 2005, allowing you to ... Continue Reading

• Stored procedure to monitor long-running jobs in SQL Server 2000

  Monitoring long-running jobs in SQL Server 2000 is not a simple practice, but it is a best practice among DBAs. In this tip, try out a stored procedure that easily identifies long-running jobs. You'll also receive email alerts about these jobs that ... Continue Reading

• Five sqlcmd features to automate SQL Server database tasks

  Make your life easier with the sqlcmd tool in SQL Server 2005 that automates administration and maintenance via scripting. In this tip, you'll get five useful features and examples to execute sqlcmd commands, such as for utilizing and populating ...Continue Reading

• Simplify queries with SQL Server 2005 common table expressions (CTEs)

  Common table expressions (CTEs) are a handy alternative to using derived tables and views in SQL Server 2005 for retrieving data. There's no need to repeat complex code because CTEs separate code into unique units and they're self-referencing within...Continue Reading

• Command to seed identity column in a SQL Server table

  Take a look at this command using a variable to seed an identify column in a SQL Server table.Continue Reading

• Should I use the SQL Server INSTEAD OF trigger to update a table, or a regular trigger?

  Find how to use the INSTEAD OF trigger to update a SQL Server table for myDate and myTime.Continue Reading

• SQL Server blob data types for accessing and storing data

  When storing blob data, you can choose from various data types. In this tip, SQL Server architect Denny Cherry examines each data type and explains how to store and access the blob data.Continue Reading

• Executing a trigger before SQL Server table is updated

  Triggers in SQL Server can be executed before a table is updated. Get triggers to read and extract table values before and after the table is updated.Continue Reading

• VARCHAR and NVARCHAR data types in SQL Server 2005

  Having trouble with using VARCHAR and NVARCHAR data types in SQL Server 2005 Express or Enterprise Edition? Learn which properties could be the problem.Continue Reading

• Examples of SQL Server stored procedures and parameters

  How can SQL Server stored procedures be helpful if you don't know they exist? Database architect Denny Cherry shares 18 examples of handy stored procedures and their parameters that Microsoft has not documented.Continue Reading

• Temporary tables in SQL Server vs. table variables

  Once you've written your T-SQL code, it's time to execute it. You'll most likely need a table in which to store data temporarily. SQL Server database architect Denny Cherry explains your four options while offering the pros and cons of using ...Continue Reading

• T-SQL and PL/SQL common languages for database-independent applications

  Common languages in T-SQL and PL/SQL exist to allow developers to write applications in database-independent environments. Common languages and interfaces such as ANSI and ODBC offer solutions to the database interoperability problem.Continue Reading