Problem solve

SQL Transact SQL T SQL

• Picking your cursor in SQL Server

  Learn which cursor to use with T-SQL for which situation in Microsoft SQL Server. Continue Reading

• The ACID test for T-SQL batch statements

  What is the ACID test? It's a test to determine whether a T-SQL statement is valid in Microsoft SQL Server. Continue Reading

• Sorting output with CASE expressions for custom sort orders

  Quick tip on using CASE statements with Microsoft SQL Server. Continue Reading

• Finding the Nth maximal value: An extension of the MAX T-SQL function

  This SQL Server T-SQL procedure finds the nth maximum value of the column's value in a table. Continue Reading

• Implementing Oracle's MINUS set operator in T-SQL

  This article describes how to implement the MINUS set operator that exists in Oracle SQL but unfortunately not in SQL Server 2000 T-SQL. Continue Reading

• Convert a string to the proper case

  This user-defined function takes an input string and converts it to upper and lower case (or proper case) format.Continue Reading

• Comparing directory structures using T-SQL

  An automatic way to compare directory structures between different SQL Sever installations.Continue Reading

• Changing the date and time in SQL Server using T-SQL

  A quick commmand that changes the date and time in SQL Server, complete with warnings!Continue Reading

• Stored procedures: Implement full text search

  Here are the steps to take to implement full text search using T-SQL stored procedures.Continue Reading

• Writing T-SQL functions to SQL Server system schema

  Writing T-SQL functions to a SQL Server system schema for use by the entire server is explained.Continue Reading

• Adding an ORDER BY clause to a view in SQL Server

  Microsoft says that you cannot put an ORDER BY clause in the view definition with SQL Server. True...unless you do the following trick!Continue Reading

• A quick UNION ALL trick for DBAs

  Use UNION ALL to get all the records from parent and child tables that have columns of text data type.Continue Reading

• Avoid blocking in Microsoft SQL Server administration

  Learn why you should avoid blocking in SQL Server, a classic database problem in which a transaction locks a first record and then a second record.Continue Reading

• Extracting field information from SQL Server

  Use this single T-SQL command to extract field information from SQL Server and into a Microsoft Word document.Continue Reading

• Complex grouping of strings in T-SQL

  This tip will show you how to group strings based on one or more IDs in Microsoft SQL Server.Continue Reading