Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in t-sql

Sort by the largest value across multiple columns

sql sql-server t-sql

PATINDEX and SUBSTRING not returning correct values

In SQL Server, how to reduce the number of columns displayed when using Select Top 1000 Rows?

sql-server t-sql

EXECUTE @Var character limit SQL Server 2008 R2

How to perform this select?

sql sql-server t-sql

how to get a percentage depending on a column value?

Query thought in sets?

sql sql-server t-sql

Why we should use QUOTENAME function?

sql-server t-sql

How to keep a rolling checksum in SQL?

sql t-sql

Copy big procedure between schemas

MSSQLSRV - filtering out results with duplicate row

sql sql-server t-sql etl

Query slows down if a unused join is removed

sql-server t-sql

Is a sort of foreach statement possible in t-sql?

sql-server t-sql foreach

using CTE (common table expressions) in a query

sql sql-server t-sql

T-SQL: Is the variable NVARCHAR(MAX)?

sql-server t-sql

Multiple SQL columns into 1 json column

How to aggregate JSON in SQL Server?

sql sql-server t-sql

SQL Update if null add 1 otherwise add 1 to current value

sql sql-server t-sql

WHERE with CASE and null checking

sql t-sql date null where-clause

SQL Server update statement with join