Problem solve

SQL Transact SQL T SQL

• Using self joins in SQL Server

  Self joins are useful when you have a nested SQL query with the inner and outer queries referencing the same table. Continue Reading

• Data restriction using CHECK constraints

  How to use the CHECK command to verify formats as well as ranges and matches. 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

• Automatically formatting your T-SQL code

  An easy method to properly format your code with capitalization, indents, spacing, etc. using T-SQL coding in Microsoft SQL Server.Continue Reading

• Find the product of a field in Microsoft SQL Server

  This function will produce the product of a field or set of values in SQL Server 2000.Continue Reading

• Avoid joining tables on a range in SQL Server

  An example of a query to avoid: Even when columns are indexed and the result set is only one row, SQL Server can choke.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