How to best write a TSQL script to create or alter a stored procedure that has a table-value type as...

How to get identity of another table record inside after insert trigger caused by a transaction for ...

There is already an object named '#columntable' in the database...

How to alter a function with dozens of dependencies?...

Getting a count dynamically for Customers first time orders and also orders lost after last order da...

Replacing RAISERROR with THROW...

Paging with TSQL, MVC3 and SubSonic?...

Problem with SQL Query Tracking...

How can I get TSQL from easy MS Access SQL with little to no handiwork?...

Each GROUP BY expression must contain at least one column that is not an outer reference...

How do I perform a GROUP BY on an aliased column in SQL Server?...

SQL Server pivoting on data without an aggregate...

SQL Server PRINT SELECT (Print a select query result)?...

"Dynamic" tables in SQL?...

SQL Merge SOURCE order and OUTPUT order...

Output of update statement does not show correct row number...

Date and time range filter in SQL...

Replace duplicate spaces with a single space in T-SQL...

Best approach to remove time part of datetime in SQL Server...

Varchar datetime with EDT in it convert into datetime...

SQL Server Restore Error: Directory lookup for the file "db.mdf" failed...

Stopping repeated XML Headers...

How do I sort "SELECT INTO" queries that are built on top of each other by their "INT...

Selecting a Common ID where that ID Matches Certain Criteria...

Error: Recursive common table expression 'EmailLog' does not contain a top-level UNION ALL o...

SQL Procedure for booking flights...

T-SQL "partition by" results not as expected...

Select first occurrence of a value per group with condition based on the most recent record of group...

How to Join to first row...

Get 2 Digit Number For The Month...