Trigger AFTER INSERT, UPDATE, DELETE to call stored procedure with table name and primary key...

Using CASE Statement in Stored Procedure...

Labor Day Vs. Thanksgiving...

Create a temporary table with identity column...

Conditionally filter results of query based on a single flag...

Anybody using SQL Source Control from Red Gate...

Returning Field names as part of a SQL Query...

How to return only the Date from a SQL Server DateTime datatype...

Reading JSON array as one of the SQL table column...

Efficient way to forward-fill nulls in time-series data using T-SQL...

convert Excel Date Serial Number to Regular Date...

Datetime function: semester, quarter...

Get previous non-NULL value based on LAG function with dynamic offset...

Pad a string with leading zeros so it's 3 characters long in SQL Server 2008...

T-SQL Change Data Capture log cleanup...

Creating stored procedure in another database...

How to mitigate "No columns were selected" exception from GridReader...

How to escape a string for use with the LIKE operator in SQL Server?...

Get all data from the range of date including no record...

How to SUM by parent table value while ignoring child table cardinality?...

Insert into select from SQL query with both query and static values...

Is there a way to calculate correlation in TSQL using OVER Clauses instead of CTE's?...

Calculate data based on days and weeks in SQL...

Get second highest salary, return null if no second highest...

TSQL, break period by Month only for given year...

Correlate these tables dynamically (or automated)...

Round to the closest .25...

What are row, page and table locks? And when they are acquired?...

Aggregate into custom groups...

Work with multiple where statements with different conditions...