Search code examples
Combine overlapping date ranges...

sqlsql-servert-sql

Read More
Why ISDATE() is returning 9996 as date?...

sql-servert-sqlsql-server-2022

Read More
IsDate Function in SQL evaluates invalid dates as valid...

sqlsql-servert-sql

Read More
Parse TEXT datatype column to grab values based on TAGS...

sql-servert-sqlsubstring

Read More
SQL YEAR(GETDATE())...

sqlsql-servert-sqlvariables

Read More
VIEW with NOLOCK but called without NOLOCK...

sql-servert-sqlviewnolock

Read More
SQL Merge WHEN NOT MATCHED BY SOURCE THEN on filtered source and targed tables...

sqlsql-servert-sqlmergesql-merge

Read More
Remove Identity from a column in a table...

sqlsql-servert-sql

Read More
How to find Cyrillic font (russian characters)?...

sqlsql-servert-sqlunicodefonts

Read More
Counting DISTINCT over multiple columns...

sqlsql-serverperformancet-sqlquery-optimization

Read More
I need a slow query on AdventureWorks (SQL 2005)...

sqlsql-serversql-server-2005t-sqlquery-optimization

Read More
Maintainable INSTEAD OF trigger with Identity columns...

sql-servert-sqltriggersidentitymaintainability

Read More
Read Dynamics NAV Table Metadata with SQL...

t-sqlblobzlibdynamics-navdeflatestream

Read More
How do I perform a simple string mapping as part of a t-sql select?...

sqlsql-serversql-server-2008t-sql

Read More
Convert ANSI to UTF in T-SQL, replacing German Umlaut 'ß' results in replacement of &#3...

jsont-sqlhttprequestutfansi

Read More
Microsoft Access SQL query...

sqlsql-servert-sqlms-access

Read More
SQL Server convert decimal to EBCDIC...

sql-servert-sqlebcdic

Read More
Delete duplicate records in SQL Server?...

sqlt-sqlduplicatesdelete-row

Read More
Aggregating IDs within a PARTITION BY query...

sqlt-sqlazure-sql-databaseaggregate-functions

Read More
Check for changes to a SQL Server database?...

sqlsql-serverdatabaset-sql

Read More
In a junction table, should I use a Primary key and a unique constraint, or a compound/composite key...

sql-servert-sqlcompound-key

Read More
Convert to ASCII char in SQL Server...

sql-servert-sqlsql-server-2012

Read More
SQL transaction locks query weird behavior...

sqlsql-servert-sqltransactions

Read More
Update SQL with consecutive numbering...

sql-servert-sql

Read More
Export stored procedure results as CSV (UTF 8 BOM format) to external server from SQL Server 2012...

sql-serverpowershellt-sqlsql-server-2012

Read More
What does the new stored procedure default content mean? ...

sqlt-sqlstored-procedures

Read More
Why does a WHERE IN query on a uniqueidentifer column result in a "range seek" (greater th...

sql-servert-sqlquery-optimization

Read More
How to grant database user read/write access roles the "new way"?...

sqlsql-serversql-server-2008t-sql

Read More
Dynamic sql script to generate list of drop table statement...

sqlsql-servert-sql

Read More
How do I remove non-breaking spaces from a column in SQL server?...

sql-servert-sql

Read More
BackNext