#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...
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 have to created a function to create a datetime from...
Function for see the difference between dates in working days. CREATE FUNCTION dbo.DifferenceWorkingDays (@Data1 AS DATE, @Data2 AS DATE) RETURNS...
Add only working date to a function, skip saturdays and sundays. CREATE FUNCTION dbo.AddWorkingDays(@Data AS DATE, @Giorni AS INT) RETURNS...