The index entry of length exceeds the maximum length of 1700 bytes for nonclustered indexes

SQL Server 2016 and Azure SQL database have increased the maximum size for index keys for non-clust ...

Read and Write XML file used LINQ in C#

XLinq is . NET Language Integrated Query for XML Data It takes advantage of the Standard Query O ...

Canada Open Work Permit for H-1B Visa holder

The application process opened on July 16, 2023, and will remain open until 10k applications are re ...

Error: Failed to get resource ID for resource type Microsoft.Web/Sites

bYellow1. red.Error: Failed to get resource ID for resource type 'Microsoft.Web/Sites' and resourc ...

How to Encrypt and Decrypt a string in SQL Server

To encrypt and decrypt a string we SQL Server 2008 and newer versions have predefined Cryptographic ...

Download Html to Word Document

HTML: HyperText Markup Language, is a Web format file. DOC: Microsoft Word Document, is a file w ...

Difference between Add and Append methods of a list in C#

List.Add() Add method will modify the instance of the list and adds a single item to the end of ...

Difference Between Add vs AddRange & Insert vs InsertRange in ArrayList C#

h3.Add() vs AddRange() List.Add() Adds an element to the end of the List. cd_////synta ...

How to Read Excel File to DataTable using ClosedXML in C#

ClosedXML libraries used to work with Excel Files such as reading Excel data to DataTables and writ ...

SQL Server MERGE Statement to insert, update and delete

MERGE statemen runs insert, update, or delete operations on a target table from the results of a jo ...