sql-server

Error: Muliple files found matching pattern ./*.sql

Regular Expression Replace (REGEXP_REPLACE) in SQL Server

Execute Azure SQL Statements Periodically via Azure Automation

Call SQL Server Stored Procedure in Python

Spark (PySpark) - 从SQL Server数据库中读取数据

Use Python Kernel in Azure Data Studio Notebook

How to Create User for Azure SQL Database

Spark Scala: Load Data from SQL Server

Calculate MD5 , SHA256, SHA512 in SQL Server

Azure SQL Database Automated Backup Strategy

AttributeError: type object 'java.sql.Types' has no attribute '__javaclass__'

Save DataFrame to SQL Databases via JDBC in PySpark

Connect to SQL Server via JayDeBeApi in Python

Python JayDeBeApi module allows you to connect from Python to databases using Java JDBC drivers.

Spark Read from SQL Server Source using Windows/Kerberos Authentication

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.

Calculate time difference in T-SQL / SQL Server

JDBC Integrated Security, NTLM and Kerberos Authentication for SQL Server

Configure a SQL Server Database as Remote Hive Metastore

Connect to SQL Server in Spark (PySpark)

Load Data into HDFS from SQL Server via Sqoop

A New SQL Server Client Tool - SQL Operations Studio

Connecting Apache Zeppelin to your SQL Server

Querying Teradata and SQL Server - Tutorial 2 Filtering and Sorting

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

Create OLAP Project using SSAS

Build Online Product Management Website using MVC 3 + Entity Framework + 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.

Useful T-SQLs (Part I)

使用SQL Server 自带功能简化SQL

使用SQL Server Integration Services(SSIS)

SQL Azure 动手实践教程

SQL Azure 概览与总结

本文总结了SQL Azure特性。SQL Azure数据库是微软提供的云端数据库服务，其体系结构参考如下图。

SQL Server 行列互相转换、合并

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

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

SQL Server中的联合主键、聚集索引、非聚集索引

理解SQL Server中的索引（一）

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

SQL Server - FOR XML AUTO 添加根节点

这篇文章展示如何通过SQLServer中的 FOR XML AUTO结果中添加XML根节点。