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