Search code examples
T-SQL: what COLUMNS have changed after an update?...

sql-serversql-server-2005t-sql

Read More
is there any possible simplification of the SQL PIVOT operator?...

sqlsql-servert-sql

Read More
Find index of last occurrence of a sub-string using T-SQL...

sql-serverstringt-sqlsearchsql-server-2000

Read More
Get the absolute date difference...

sql-servert-sql

Read More
Dynamic Pivot with group by, dynamic column name and dynamic column list...

sql-servert-sql

Read More
The last day of the previous month - BigQuery...

sqlt-sqlgoogle-bigquery

Read More
Fastest way to find which hours have 0 rows in a table with a month's data?...

sql-servert-sqlquery-optimization

Read More
Set IDENTITY_INSERT ON is not working...

sql-serversql-server-2008t-sql

Read More
Joining empty table to return all rows...

sqlsql-serversql-server-2005t-sql

Read More
Why does TRY_CAST() / TRY_CONVERT() take so overly long for a view outer joined on itself but each s...

t-sqlquery-optimization

Read More
How to calculate age (in years) based on Date of Birth and getDate()...

sqlsql-servert-sql

Read More
Does T-SQL have an aggregate function to concatenate strings?...

sql-serversql-server-2005t-sqlgroup-byaggregate-functions

Read More
ANSI_NULLS and QUOTED_IDENTIFIER killed things. What are they for?...

sqlsql-servert-sqlsql-server-2012

Read More
Create view with primary key?...

sql-servert-sqlprimary-keysql-view

Read More
CROSS APPLY OPENJSON on Dictionary<string, object[]>...

t-sqlazure-synapsecross-applyopen-json

Read More
Check if table exists in SQL Server...

sql-servert-sqlsql-server-2005sql-server-2000

Read More
Check if table exists and if it doesn't exist, create it in SQL Server 2008...

sqlsql-servert-sqlsql-server-2008-r2

Read More
Column has a data type that cannot participate in a columnstore index...

sql-servert-sqlcolumnstore

Read More
Extracting Email from string in SQL Server...

sqlsql-servert-sqlsubstringcharindex

Read More
How to calculate Count of Columns that greater than zero...

sql-servert-sql

Read More
Using Subquery or INNER JOIN...

sql-servert-sql

Read More
SQL Server : trigger error invalid object name 'deleted'...

sqlsql-servert-sqltriggers

Read More
Assign Null to a column in a CTE...

sql-servert-sql

Read More
T-SQL - Assign field to NULL in a case statement...

sql-servert-sql

Read More
In SQL Server, how to concat --> group by using the concat column...

sqlsql-servert-sql

Read More
In SQL, how can you "group by" in ranges?...

sqlsql-servert-sql

Read More
Creating the same view in multiple tenant databases using a stored procedure...

sqlsql-servert-sqlmulti-tenantdynamic-sql

Read More
SQL Query to group data without using cursor...

sqlt-sqldatabase-cursor

Read More
Does the 128 character limit for table names include the database name and schema name?...

t-sqlsql-server-2008-r2

Read More
How to filter GET query Blazor-Server web app for a small number of records from a million rows tabl...

c#sql-servert-sqlentity-framework-coreblazor-server-side

Read More
BackNext