Problem solve
Get help with specific problems with your technologies, process and projects.
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