How to get the next identity value from SQL Server...

How to search SQL column containing JSON array...

Running total over duplicate column values and no other columns...

How can I reliably store an ID so that I can use it in another INSERT statement?...

History Table To From Dates trying to record specific column change...

How to find out SQL Server table's read/write statistics?...

How can I use a variable to drop a table such as: DROP TABLE @dbname?...

Sybase: How do I concatenate rows in sybase column...

how to make your data horizontal...

Types don't match between the anchor and the recursive part in column "Text" of recurs...

How can I determine if a set of rows in one table (with a specific id) represents all of the rows in...

Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)...

T-SQL MAX Window Function not working as expected...

How to roll back the changes if trigger failed...

CONVERT fails but TRY_CONVERT successfully convert same data...

Should the predicate from a filtered index be in the front or back of the index?...

Does SQL Server Offer Anything Like MySQL's ON DUPLICATE KEY UPDATE...

How can I add a whole column of data as a row?...

SQL Server trigger with error message...

Find the number of return calls that were done by customer care within 30 minutes of the missed call...

Improving Performance of Recursive CTE for calculating totals...

UPDATE Statement Not Updating in Execute T-SQL Task...

linked server OLE DB provider "SQLNCLI11" for linked server...

Display running totals in SSRS in a shape of triangle for Los Development (Loss Triangle) report...

In a T-SQL table of prizes awarded, how can I find all users that received two specific prizes?...

How to create a derived attribute from a foreign table using Alter Table?...

SUM over with distinct...

create TVC ("Table Value Constructor") script from temp table (same like SSMSBoost provide...

Find corresponding records over multiple columns for each key value given a sort order...

How to get the last plus and last minus datetime from a stock table...