New posts in T Sql

How to escape XML characters in TSQL before converting to XML?

If positive, sum all items. If negative, return each one

Is there a way to make this select retrieve the same results with a single seek?

SQL query failing because of commented part of T-SQL query

T-SQL: If parameter1 is null, use parameter2

Should I add an auto-increment / IDENTITY field to a cross-reference table just for PK purposes?

Same code in multiple stored procedures

Is there a T-SQL equivalent for punctuation as [0-9] is for numbers and [a-z] is for letters?

How to get the current line number from an executing stored procedure

Recursive CTE to find Total for all children