Search code examples
How to use Trim in select queries for data in SQL tables...


sqlsql-serversql-server-2019

Read More
Only two objects + rest the count...


sql-serversql-server-2019

Read More
How do I select the last non-empty value for a given ID and date...


sqlsql-servert-sqlsql-server-2019

Read More
Couldn't run the SQL Server 2019 installation file on Windows 11...


sql-serverinstallationsql-server-2019windows-11sql-server-2019-express

Read More
CAST to TIME in select query is taking long time to execute...


sqlsql-serversql-server-2019

Read More
How to prevent SQL Server from stripping leading zeros when importing data...


sql-serverapache-sparkazure-sql-databasesql-server-2019

Read More
SQL Server Change Data Capture - Validating Incremental Window...


sql-serverazure-data-factorysql-server-2019change-data-capture

Read More
ERROR: Unsupported PIVOT column type: text...


sql-servert-sqlpivotsql-server-2019

Read More
How to return all rows in a column when using cross apply and DelimitedSplit8K_LEAD together in SQL ...


casesql-server-2019cross-apply

Read More
How can I write a case sensitive WHERE CLAUSE in SQL Server?...


sqlsql-serverwhere-clausecase-sensitivesql-server-2019

Read More
Parsing XML Data using T-SQL...


sql-serverxmlt-sqlxquerysql-server-2019

Read More
Extract data from XML document using t-sql...


sql-serverxmlsql-server-2019

Read More
Trigger to delete the record from the table if it exists in it...


sqlsql-servertriggerssql-server-2019

Read More
SQL statement: SELECT data based on a condition...


sqlsql-serversql-server-2019

Read More
Create function to returned the set of rows bases on the input parameter...


sqlsql-serversql-server-2019

Read More
SUM Values by Sequence Number and Group By Flag...


sqlsql-serversql-server-2016sql-server-2019

Read More
Same code errors in a Stored Procedure, works in T-SQL...


sql-serversql-server-2019

Read More
using STRING_AGG and the LAST_VALUE function in same request...


sql-servert-sqlaggregate-functionswindow-functionssql-server-2019

Read More
@@DATEFIRST not returning results as described in the docs...


sql-serverdatet-sqlsql-server-2019

Read More
Why doesn't select using like query in json string?...


sqlsql-serversql-likesql-server-2019

Read More
Create groups based on 14 day interval...


sqlsql-serversql-server-2019

Read More
WIndows Server 2019 + SQL Server 2019 Enterprise Performance Issues (vs Win Server 2016)...


ssissql-server-2019windows-server-2019

Read More
Why SSIS packages are saved into PackageName______V0.7z archive?...


ssisvisual-studio-2019sql-server-2019

Read More
Query returns different result from C# then from SSMS...


c#datatablesql-server-2019sqldataadapter

Read More
How do I find rows that contain two words "First" + "Second" regardless sequence...


sqlsql-serversql-server-2019

Read More
Stored procedure to enter Results into a table...


sqlsql-serversql-server-2019

Read More
Trimming a nvarchar param in SQL Server 2019...


sqlsql-serversql-server-2019

Read More
Attempted to perform an unauthorized operation when executing SQL Server 2019 service pack...


sql-serverinstallationsql-server-2019servicepacks

Read More
How to import flat file with duplicate primary key records into SQL table...


sql-serverssisetlupsertsql-server-2019

Read More
Loop through table and update a specific column...


sqlsql-servert-sqlsql-server-2019

Read More
BackNext