mssql

15 items tagged with "mssql"

15 Articles

Articles

Regular Expression Replace (REGEXP_REPLACE) in SQL Server

2022-06-04
SQL Server

How to Create User for Azure SQL Database

2021-08-12
Microsoft Azure

Export CSV File from Azure SQL Databases

2021-08-12
Microsoft Azure

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.

2019-11-18
Code Snippets & Tips

Convert string to date in T-SQL / SQL Server

This code snippet shows how to convert string to date.

2019-11-18
Code Snippets & Tips

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.

2019-11-18
Code Snippets & Tips

Calculate time difference in T-SQL / SQL Server

2019-11-18
Code Snippets & Tips

Querying Teradata and SQL Server - Tutorial 2 Filtering and Sorting

2015-05-04
Teradata

Querying Teradata and SQL Server - Tutorial 0: Preparation

2015-05-02
Teradata

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

2014-09-12
SQL Server

SQL Server - Using CLR Types and Functions

In this article, I am going to demonstrate how to use CLR (Common Language Runtime) data types and functions in SQL Server.

2013-11-10
SQL Server

使用SQL Server 自带功能简化SQL

2013-06-01
SQL Server

连接同一台电脑/服务器的多个SQL Server 的数据库实例

2010-09-24
SQL Server

理解SQL Server中的索引(一)

2009-12-17
SQL Server

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

2009-10-20
SQL Server