Search code examples
Fill down from a specific row based on criteria...


sql-servert-sql

Read More
Drop group of stored procedures by name...


sqlt-sqlstored-procedures

Read More
different deleting OUTPUT behaviour based on source table...


sql-servert-sqlmergesql-delete

Read More
Is "SET NOCOUNT OFF" necessary in a stored procedure?...


sqlsql-servert-sqlnocount

Read More
SQL Server: Update table based on JSON...


sqljsonsql-servert-sql

Read More
Find the first occurrence of a string that's NOT within a set of delimiters in SQL Server 2016+...


sqlsql-servert-sql

Read More
ULID datatype in SQL Server database...


sql-serverdatabaset-sqluuidulid

Read More
How to get biweekly dates per month in a year in SQL Server?...


sqlsql-servert-sql

Read More
Convert an existing Column to Identity...


sqlsql-servert-sqlsql-server-2012

Read More
Trigger for rows where specific column was changed...


sqlsql-servert-sqltriggers

Read More
varbinary to string on SQL Server...


sqlsql-serversql-server-2005t-sql

Read More
Create nested JSON arrays using FOR JSON PATH...


jsonsql-servert-sqlsql-server-2016

Read More
How to drop a table if it exists?...


sql-servert-sql

Read More
Restoring database from backup with NoRecovery option is getting stuck in Recovery state...


c#sql-servert-sqlrecovery

Read More
Return condition from CASE expression in where clause (error: incorrect syntax near '<'.)...


sqlsql-servert-sqlsql-server-2022

Read More
Executing SQL Server Agent Job from a stored procedure and returning job result...


sqlsql-serversql-server-2008t-sqljobs

Read More
How can I truncate a datetime in SQL Server?...


sqlsql-servert-sqldatetimetruncate

Read More
Generate random characters in stored procedure...


sqlsql-servert-sqlstored-proceduressql-server-2016

Read More
SQL Job to Pipe Delimited...


sqlsql-servert-sql

Read More
Visual Studio thinks correct SQL syntax is incorrect...


t-sqlvisual-studio-2013syntax-errordatabase-project

Read More
What makes my T-SQL query non-composable and therefore non-compatible with EF Core's SqlQuery?...


sql-servert-sql.net-coreentity-framework-core

Read More
Triggers: Instead of / For Insert, which will trigger first?...


sqlsql-servert-sql

Read More
How to optimize a query?...


sql-servert-sqlquery-optimization

Read More
Convert varchar into datetime in SQL Server...


sqlsql-serversql-server-2008t-sqltype-conversion

Read More
Getting list of tables, and fields in each, in a database...


sqlt-sql

Read More
How to retrieve data between pipes (delimiter) in string...


sqlsql-servert-sql

Read More
Automatically match columns in INSERT INTO ... SELECT ... FROM ...


sqlsql-servert-sqlselectinsert

Read More
Do clustered indexes have to be unique?...


sqldatabaset-sqlsql-server-2008clustered-index

Read More
Replace a newline in TSQL...


t-sqlnewline

Read More
Query to get Value in row split with virgula character...


arraysjsonsql-servert-sqlsql-server-2016

Read More
BackNext