Problem solve

SQL Transact SQL T SQL

• Data restriction using CHECK constraints

  How to use the CHECK command to verify formats as well as ranges and matches. Continue Reading

• Key differences between SQL CAST vs. CONVERT functions

  Learn how the MSSQL CAST vs. CONVERT functions operate -- and the best time to use each 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

• 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

• 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

• 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