Search code examples
How to pass an array into a SQL Server stored procedure...


c#sql-servert-sqlstored-procedures

Read More
Error trying copy a table into another without duplicates...


sqlsql-servert-sql

Read More
How to safely change the unique key with Entity Framework - database-first...


c#visual-studioentity-frameworkt-sql

Read More
How to update only 2 columns of table and save as new record?...


c#sql-servert-sql

Read More
How can I use if statement after a CTE (SQL Server 2005)...


sqlsql-serversql-server-2005t-sqlcommon-table-expression

Read More
SQL Scheduled job query, duration of last runs?...


sql-servert-sqlsql-server-2000

Read More
SQL XML How to query specific node...


sqlsql-serverxmlt-sql

Read More
How to concatenate T-SQL script with a wildcard and to be more dynamic?...


sql-servert-sqlconcatenationsql-server-2019

Read More
Text was truncated or one or more characters had no match in the target code page including the prim...


sqlsql-servert-sqlssis

Read More
How do you change the datatype of a column in T-SQL Server?...


sql-servert-sqltype-conversionalter-table

Read More
Count just working days (exclude weekends and public holidays) and add filter that a query...


sqlsql-servert-sqldatetimesql-server-2008-r2

Read More
Fill remaining dates between dates in SQL Server...


sql-serverdatet-sql

Read More
tSQLt - How to fake/mock sequences...


sql-serverunit-testingt-sqltsqlt

Read More
Check if a varchar is a number...


t-sqlnumerical-methods

Read More
PATINDEX to detect letters and six numbers...


sqlsql-servert-sqlsql-server-2012

Read More
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
TSQL Pseudo Random text generator...


sqlt-sqlrandom

Read More
Generating random strings with T-SQL...


sqlt-sqlrandom

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
BackNext