#sql
Read more stories on Hashnode
Articles with this tag
1. XML documents in SQL Server and Azure SQL Database While JSON uses nvarchar type, XML has a dedicated column type of the same name in SQL Server...
These contents working in SQL Server 2016 and later and Azure SQL Database. 1. JSON documents in SQL Server Use nvarchar(max) data type to store JSON...
Temporal table: to provide information about data in a table at any point in time.On SQL Server from the 2016 version. -- This statement creates a...
Spark SQL is a component of Apache Spark that works with tabular data. # Load data from file df = spark.read.csv("trains.csv", header=True) # Create...
DATEFROMPARTS() function is from SQL Server version 2012 and later, working on SQL Server 2008 I had to create a function to create a datetime from...
Function to see differences between dates in working days. CREATE FUNCTION dbo.DifferenceWorkingDays (@Data1 AS DATE, @Data2 AS DATE) RETURNS...