Search code examples
De Morgan to avoid ORs in SQL Server query...

sqlsql-servert-sqldemorgans-law

Read More
Getting the max and the min paid departments...

sqlsql-servert-sqlsql-server-2012

Read More
Cannot find data type 'ntext' error in Azure SQL Data Warehouse...

t-sqlpyodbcazure-synapse

Read More
SQL Hierarchy Fill Down...

sqlsql-servert-sqlsql-server-2012

Read More
Stored procedure creation error in SQL Server 2022...

sql-servert-sqlstored-procedures

Read More
COUNT and delete of the number of duplicates from table with billion rows...

sqlsql-servert-sql

Read More
Duplicating a TABLE using Microsoft SQL Server Management...

sqlsql-servert-sqlssms

Read More
How to optimize this TSQL script (delete by iterating)?...

sql-servert-sql

Read More
procedure to drop system-versioned temporal tables...

sql-servert-sqltemporal-tables

Read More
How to check how many times CLR function was called from stored procedure without changing procedure...

sqlsql-servert-sqlsqlclr

Read More
How to use group by with union in T-SQL...

sqlsql-servert-sqlgroup-byunion

Read More
Extract Date from a comment string...

sql-serverdatet-sqlcasting

Read More
T-SQL: Looping through an array of known values...

sqlsql-servert-sql

Read More
Trying to create two columns with no NULL value and now duplicates in id col...

sql-servert-sqlazure-synapse

Read More
SQL query to determine that values in a column are unique...

sqlsql-servert-sql

Read More
sp_getapplock without transaction...

sql-servert-sqllockingsql-server-2008-r2

Read More
Enforce a unique constraint on a business key in single table...

sql-servert-sql

Read More
Upper and lower limit based on hour...

datet-sqlsalesforce-marketing-cloud

Read More
Why do two Deletes with different IDs but on same table cause a deadlock...

sql-servert-sqldeadlock

Read More
How to convert a query and not call the subquery several times?...

sqlsql-servert-sqlstored-procedures

Read More
Transform a string result table from rows to columns...

sql-servert-sqlpivot

Read More
Same Row_Number for Same Values...

sqlsql-servert-sqlsql-server-2008

Read More
How Do I Get Order Total Based on Counts and Groupings...

sqldatabaset-sql

Read More
SQL Server: How to find what lines are executed...

sql-servert-sqlcode-coveragestatements

Read More
T-SQL FOR XML EXPLICIT - add attribute "xsi:nil" to elements...

sql-serverxmlt-sql

Read More
How to loop through all SQL tables?...

sqlsql-serverloopst-sql

Read More
How do I split a delimited string so I can access individual items?...

sqlsql-servert-sqlsplit

Read More
Can we use 'xp_logininfo' to compare and find duplicate groups?...

sqlt-sqlsecurityactive-directoryuser-permissions

Read More
Sql Recursive Query Adding Amount...

sqlsql-servert-sql

Read More
Select all columns from all tables in SQL Server 2008...

sqlsql-servert-sqlsql-server-2008

Read More
BackNext