Search for a command to run...
Articles tagged with #sql-server
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 and Azure SQL Database. -- Create table and insert data for the examples CREATE TABLE [dbo].[XMLexampl...
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 documents up to 2 GB in size in a column of a SQL Server table. If your JSON is less then 8 KB is re...
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 Temporal Table CREATE TABLE dbo.ExampleTemporal ( Id INT NOT NULL PRIMARY KEY CLUSTERED, Col1 I...
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 HRESULT: 0xC020204A Error at From SQL Server to Excel [OLE DB Source [91]]: SSIS Error Code DTS_E_OLE...
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 format. SOLUTION: use a C# script instead the Send Mail Task to create and send the email. Add a Scrip...
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 convert between unicode and non-unicode". SOLUTION Add a Data Conversion task between Source and ...