Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in t-sql

Table join on dynamic table names

sql sql-server t-sql join

Use table hints with variable table

What is the difference between using `IF @@TRANCOUNT > 0` vs `XACT_ABORT` approach to rollback transaction? When do I use either of this approach?

sql-server t-sql

Deterministic function for getting today's date

How to ignore string value using unpivot function finding the min value among other columns

CASE statement using DateTime column

sql t-sql

SQL Left Join two tables into one

sql sql-server t-sql

How to count in multiple columns a variable

Forcing a SQL Remote Query to filter remotely instead of locally

Display record between today's date and 6 months before

Avoid subqueries when grouping over a part of a string

How to insert BIT value if row has relation

T-SQL | Find multiples (with a twist?!)

How to get a case sensitive version of a collation in SQL Server?

Stored procedure executing select statement indefinitely

Divide the coordinates into X and Y coordinates from a table having geometry data in SQL Server 2012

SQL: IS NULL not working

Count row with content for specific number of columns

Dynamic Table Insert TSQL