t-sql

Calculate MD5 , SHA256, SHA512 in SQL Server

Extract Values from JSON String Column in SQL Server

JSON is commonly used in modern applications for data storage and transfers. Pretty much all programming languages provide APIs to parse JSON.

Convert string to date in T-SQL / SQL Server

This code snippet shows how to convert string to date.

Select from dual in T-SQL / SQL Server

In Oracle database, you can select from dual table if you only want to return a one row result set. In many other databases, the query engine supports select directly from constant values without specifying a table name.

Calculate time difference in T-SQL / SQL Server

Querying Teradata and SQL Server - Tutorial 2 Filtering and Sorting

Querying Teradata and SQL Server - Tutorial 1: The SELECT Statement

Useful T-SQLs (Part I)

SQL Server 行列互相转换、合并

在数据库查询中，我们经常需要将数据库中的行与列互相转换；本文将对这些转换进总结，以供参考。