Search code examples
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
How do I find a disabled index on SQL server 2008...


sql-servert-sqlsql-server-2008

Read More
SQL: listing many-to-many from single query...


sql-servert-sql

Read More
Unwanted trigger fired though trigger's conditions do not satisfy...


sql-servert-sqltriggers

Read More
BackNext