t-sql Examples and Free Source Code

Сomplex delete duplicates...

sql sql-server t-sql

Altering column size in SQL Server...

sql sql-server database t-sql alter-table

SQL Gaps and Islands with multiple overlapping criteria...

sql sql-server t-sql gaps-and-islands

Compare DATETIME and DATE ignoring time portion...

sql sql-server t-sql sql-server-2008 datetime-conversion

Is Int 1 always implicitly converted to 1 day?...

sql-server t-sql types implicit-conversion

CREATE LOGIN - can't use @parameter as username...

sql sql-server authentication t-sql

Select statement return if there is a value and if there is no value...

sql-server t-sql stored-procedures

Auto fill field with value from above row value...

sql sql-server t-sql row

Column name or number of supplied values does not match table definition...

sql sql-server sql-server-2005 t-sql

select data up to a space?...

sql-server t-sql

T-SQL use EXISTS as Column...

sql-server t-sql exists

SQL Retrieving data from last record with Group BY...

t-sql group-by

SQL "select where not in subquery" returns no results...

sql sql-server t-sql

Perform an aggregate function on an expression containing an aggregate...

sql sql-server t-sql group-by

How to do Select from a dynamic variable inside a store proc in sybaseASE...

t-sql sybase sap-ase

Get xml-path from a node selected from a document...

sql-server t-sql xpath xquery

Cannot produce characters of the supplementary plain of Unicode (SC) from their codepoint...

sql-server t-sql unicode supplementary

Ole Automation Procedure returns null...

sql-server t-sql ole-automation

How to get last character of a string in sql server...

sql-server t-sql

Select hierarchy from table...

sql sql-server t-sql hierarchical-data recursive-query

CROSS JOIN vs INNER JOIN in SQL...

sql sql-server sql-server-2008 t-sql cross-join

Replacing a specific Unicode Character in SQL Server...

sql-server t-sql replace unicode-string

Msg 178, Level 15, State 1, Line 8 A RETURN statement with a return value cannot be used in this con...

sql sql-server sql-server-2008 t-sql sql-function

How do I pass the SQL Server Job name to a stored procedure inside this job?...

sql sql-server t-sql token sql-job

Function to Calculate Median in SQL Server...

sql-server t-sql aggregate-functions median

How to use an identity column for both automatic values and manual inserts?...

sql-server t-sql identity-insert

How to store a tree in SQL database...

sql sql-server t-sql hierarchical-data

Get top 1 row of each group...

sql sql-server t-sql greatest-n-per-group

One INSERT with UNIONS or multiple INSERTS?...

sql sql-server sql-server-2005 t-sql

Recover unsaved SQL query scripts...

sql sql-server t-sql sql-server-2012 ssms