New posts in tsql

Is there a way to enforce limited uniqueness on a SQL table?

Insert default value when parameter is null

Replace values in a CSV string

Get top first record from duplicate records having no unique identity

Attempting to concatenate multiple rows.. unexpected results

Which is better: Bookmark/Key Lookup or Index Scan

Extra Characters while using XML PATH

How we can use CTE in subquery in sql server?

T-SQL: How do I create a unique key that is case sensitive?

all substrings of a specified length

How to write customer order by in SQL Server

Get current value from a SQL Server SEQUENCE

SQL Server: how to delete rows with matching ID that were not affected by MERGE?

SQL Server check resultant data type of expression

When no 'Order by' is specified, what order does a query choose for your record set?

SQL Server 2005 and temporary table scope

MAX vs Top 1 - which is better?

Get AVG ignoring Null or Zero values

How to add "IF NOT EXISTS" to create trigger statement

How can INSERT INTO a table 300 times within a loop in SQL?