#sql-server
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...
PROBLEM: if you try to execute with a SSIS Data Flow a stored procedure containing a temporary table, you receive this error message: Exception from...
GOAL: send an html email using Sql Server Integration Service PROBLEM: the Send Mail Task in SSIS allows only email in text format and not in html...
GOAL: move data from SQL Server to Excel with SQL Server Integration Services. PROBLEM: the package doesn't work and you receive the error "cannot...