How to pass an array into a SQL Server stored procedure...
Read MoreError trying copy a table into another without duplicates...
Read MoreHow to safely change the unique key with Entity Framework - database-first...
Read MoreHow to update only 2 columns of table and save as new record?...
Read MoreHow can I use if statement after a CTE (SQL Server 2005)...
Read MoreSQL Scheduled job query, duration of last runs?...
Read MoreSQL XML How to query specific node...
Read MoreHow to concatenate T-SQL script with a wildcard and to be more dynamic?...
Read MoreText was truncated or one or more characters had no match in the target code page including the prim...
Read MoreHow do you change the datatype of a column in T-SQL Server?...
Read MoreCount just working days (exclude weekends and public holidays) and add filter that a query...
Read MoreFill remaining dates between dates in SQL Server...
Read MoretSQLt - How to fake/mock sequences...
Read MorePATINDEX to detect letters and six numbers...
Read MoreT-SQL: what COLUMNS have changed after an update?...
Read Moreis there any possible simplification of the SQL PIVOT operator?...
Read MoreFind index of last occurrence of a sub-string using T-SQL...
Read MoreDynamic Pivot with group by, dynamic column name and dynamic column list...
Read MoreThe last day of the previous month - BigQuery...
Read MoreFastest way to find which hours have 0 rows in a table with a month's data?...
Read MoreSet IDENTITY_INSERT ON is not working...
Read MoreTSQL Pseudo Random text generator...
Read MoreGenerating random strings with T-SQL...
Read MoreJoining empty table to return all rows...
Read MoreWhy does TRY_CAST() / TRY_CONVERT() take so overly long for a view outer joined on itself but each s...
Read MoreHow to calculate age (in years) based on Date of Birth and getDate()...
Read MoreDoes T-SQL have an aggregate function to concatenate strings?...
Read MoreANSI_NULLS and QUOTED_IDENTIFIER killed things. What are they for?...
Read More