Understanding Date and Time Formats in SQL Server

Constructing a URL for Web Services Using Variable Parameters

Using Grouping and Aggregation in SQL to Retrieve Multiple Values

How to Create a Trigger on SQL Server That Captures Information About Who Runs the Delete Operation

Retrieving the Latest Record Without Row_Number() in SQL Server 2000

How to Create a Dynamic Suffix for an Address Column in SQL Server Using ROW_NUMBER()

T-SQL Variable Programming: A Closer Look at Conditional Calculations

Incorporating Stored Procedure Output into Database Views: A Performance-Driven Approach for Maximum Unicode Support and Efficiency

Counting Distinct Records in SQL Databases Using GROUP BY, HAVING, and DISTINCT

Understanding Date and Time Data Types in SQL Server