Problem solve

SQL Transact SQL T SQL

• Five basic SQL Server functions you should be using

  Check out five of the most useful of the many SQL Server system functions. Continue Reading

• Have you been ODBCPing with SQL Server?

  Learn the syntax and what the command does in Microsoft SQL Server. Continue Reading

• 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

• 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