mssql

Regular Expression Replace (REGEXP_REPLACE) in SQL Server

How to Create User for Azure SQL Database

Export CSV File from Azure SQL Databases

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 0: Preparation

Generate Formatted Excel Destination (Output) in SSIS Data Flow Task

使用SQL Server 自带功能简化SQL

SQL Server 附加没有日志文件ldf的数据库mdf的方法