Hidden Features of SQL Server
Transact-SQL Count using a subselect statement filtering on a variable from top select
sql function for the most recent value in a grouping
How to check some condition on a computed column?
Error creating a trigger to skip lines on insert in MySQL
How can I remove duplicate rows?
How do I DROP multiple columns with a single ALTER TABLE statement?
SQL Server SELECT INTO @variable?
NOT IN clause and NULL values
How can I select the first day of a month in SQL?
SQL Server query - Selecting COUNT(*) with DISTINCT
Pad a string with leading zeros so it's 3 characters long in SQL Server 2008
Use variable with TOP in select statement in SQL Server without making it dynamic [duplicate]
Truncate (not round) decimal places in SQL Server
UPDATE from SELECT using SQL Server
Insert results of a stored procedure into a temporary table
How to perform an IF…THEN in an SQL SELECT?
How to return the date part only from a SQL Server datetime datatype
How can I do an UPDATE statement with JOIN in SQL?
When should I use Cross Apply over Inner Join?
Should I use != or <> for not equal in TSQL?
Function vs. Stored Procedure in SQL Server
Best way to get identity of inserted row?
SQL Server: How to Join to first row
How can I list all foreign keys referencing a given table in SQL Server?
SQL update query using joins
Select statement to find duplicates on certain fields
How do I escape a single quote in SQL Server?
SQL Server: CASE WHEN OR THEN ELSE END => the OR is not supported
How can I get column names from a table in SQL Server?