Search code examples
Identifier on yearly base...

sqlsql-servert-sqlwindow-functions

Read More
TSQL - How to URL Encode...

sqlsql-servert-sql

Read More
Keeping a constant identifying value at the beginning of a recursively unioning cte...

sql-servert-sqlhierarchical-datarecursive-cte

Read More
Databricks SQL Will Not Accept Correlated Columns Error: Correlated column is not allowed in a non-e...

sqlsql-servert-sqldatabricks-sql

Read More
How to Insert Data into Table Using SQL Server Table Using INSERT INTO query...

sqlsql-servert-sql

Read More
SQL Joins returning results from one T-SQL Query but not another...

sqlt-sqldatabricks-sql

Read More
QUOTENAME() with parenthesis, curly brackets, angle brackets, or grave accents...

sql-servert-sql

Read More
How to display value correctly between 2 tables...

sqlsql-servert-sql

Read More
Stored Proc with DataTable Parameter - How to perform conditional update without looping through the...

sql-servert-sqltable-valued-parameters

Read More
How to find column names for all tables in all databases in SQL Server...

sqlsql-servert-sqldatabase-schema

Read More
WITH CHECK ADD CONSTRAINT followed by CHECK CONSTRAINT vs. ADD CONSTRAINT...

sqlsql-servert-sqlcheck-constraints

Read More
How to Query JSON Array of unnamed objects...

sqljsont-sqlazure-sql-database

Read More
Invalid cast exception when reading result from SQLDataReader...

c#sqlsql-servert-sqlstored-procedures

Read More
Converting a VARCHAR to an INT; is TRY_CAST or TRY/CATCH better?...

sql-servert-sqlcastingtry-catch

Read More
Yet another "The cursor is READ ONLY."?...

sql-servert-sqlsql-server-2012

Read More
Is there a better way to SUM columns?...

sqlt-sql

Read More
How can I convert bigint (UNIX timestamp) to datetime in SQL Server?...

sqlsql-servert-sqldatetimeunix-timestamp

Read More
SQL Server Query - Sorting data using Order By in Union All...

sqlsql-servert-sqlsql-server-2008sql-order-by

Read More
Why is my SQL SELECT returning all NULL values from a valid JSON column?...

sqljsont-sqlselect

Read More
Comparing a value to a NULL in t-SQL...

sqlsql-servert-sqlnull

Read More
Get a specific JSON value when I have multiple array elements...

arraysjsonsql-servert-sql

Read More
Syntax error using 'FOR SYSTEM_TIME AS OF ... AT TIME ZONE' in SQL Server Temporal table que...

sql-servert-sqlsql-server-2019

Read More
Extract particular value from middle of a column which is separated by '/' and '//'...

sql-servert-sql

Read More
Reuse calculated column in HAVING clause...

sqlsql-servert-sql

Read More
Database - how to create regions in TSQL (SQL Server 2008)...

sql-servert-sqlsql-server-2008

Read More
T-SQL: How can you create a table with SELECT?...

t-sql

Read More
Trigger insert old values- values that was updated...

sqlt-sqlsql-server-2008

Read More
How to design usage of Global temp table for a multi-user environment? (or alternatives)...

sqlsql-servert-sqlpivottemp-tables

Read More
Populate a listbox in a form with recordset using MS Access VBA...

vbat-sqlms-accesslistboxrecordset

Read More
How to EXECUTE a set of stored procedures in a table...

sql-servert-sqlstored-proceduresdynamic-sqlexecute

Read More
BackNext