Search code examples
Select query to remove non-numeric characters...

t-sqlsql-server-2008-r2substringpatindex

Read More
Calculate Date Difference for Non-Consecutive Months...

sqlsql-servert-sqlwindow-functionsgaps-and-islands

Read More
Show only one database on SQL Server...

sqlsql-servert-sqlazure-sql-database

Read More
When using multiple WHEN MATCHED statements, do they all execute, or does only one get executed?...

sqlsql-servert-sqlmerge

Read More
Join SQL tables back together to create a report...

sqlsql-servert-sqlreport

Read More
Create a Range From n to 1 in SQL...

sqlsql-servert-sqlsql-server-2008-r2

Read More
How to DROP multiple columns with a single ALTER TABLE statement in SQL Server?...

sqlsql-servert-sqlalter

Read More
Split a string based on multiple variable substring...

sqlsql-servert-sqlreplacesubstring

Read More
sp_execute_remote only outputs one result set?...

t-sqlazure-sql-database

Read More
CASE or AND/OR in WHERE condition. What is the best practice?...

sql-servert-sql

Read More
TSQL rollup -return not null...

sql-server-2008t-sql

Read More
Multiple Security Predicates (FILTER|BLOCK) on same Table...

sql-servert-sqlsql-server-2016rbacrow-level-security

Read More
Parsing JSON nodes in the same string...

jsonsql-servert-sql

Read More
How can I use LEFT & RIGHT Functions in SQL to get last 3 characters?...

sqlsql-servert-sql

Read More
SQL Get "ISO Year" for ISO Week...

sqlsql-servert-sqldate

Read More
Case expression for Order By clause with Desc/Asc sort...

sqlsql-servert-sql

Read More
How to create and use database directly after creation in SQL Server?...

sqlsql-serverdatabaset-sql

Read More
Database Naming Conventions by Microsoft?...

sqlsql-servert-sql

Read More
How to compare values which may both be null in T-SQL...

sqlsql-servert-sqlstored-procedures

Read More
What is the difference between SYSTEM_USER and USER in SQL server?...

sql-servert-sql

Read More
What is the proper use of a clustered index?...

sql-servert-sqlclustered-index

Read More
Resolving Poor Execution Plan in SQL Server with CLR Scalar Function...

sql-servert-sqlquery-optimizationsqlclrquery-planner

Read More
T-SQL - stored procedure - "IF EXISTS" vs. "WHERE EXISTS"...

sql-servert-sqlstored-proceduresif-statementwhere-clause

Read More
Missing libtdsodbc.so in freetds-dev - MSSQL on Ubuntu...

sql-servert-sqlubuntuodbcfreetds

Read More
Conditional update either column1 or column2 or column3...

sqlsql-servert-sql

Read More
Generating self-closing XML tags for lists in SQL Server...

sql-servert-sqlsql-server-2019for-xmlselect-for-xml

Read More
Where value in column containing comma delimited values...

sqlsql-servert-sqlsql-server-2008csv

Read More
SQL Server error on update command - "A severe error occurred on the current command"...

sql-serversql-server-2005t-sql

Read More
Table function in SQL Server with multiple parameters as an argument...

sql-servert-sqlunpivottable-functions

Read More
Is it possible to add index to a temp table? And what's the difference between create #t and dec...

sqlsql-servert-sqlindexingtemp-tables

Read More
BackNext