Basic SQL

CREATE TABLE [dbo].[Country] (
    [CountryId]     INT           IDENTITY (1, 1) NOT NULL,
    [Name]    VARCHAR (50)  NOT NULL,  
    PRIMARY KEY CLUSTERED ([CountryId] ASC)
);

CREATE TABLE [dbo].[State] (
    [StateId]     INT           IDENTITY (1, 1) NOT NULL,
[CountryId] int,
    [Name] int NOT NULL,  
    PRIMARY KEY CLUSTERED ([StateId] ASC),
    FOREIGN KEY (CountryId) REFERENCES Country(CountryId)
);

Error: unknown property is memory optimized (microsoft.sqlserver.management.sdk.sfc)

Download hotfix
https://support.microsoft.com/en-us/hotfix/kbhotfix?kbnum=3011055&kbln=en-US

A popup blocker may be preventing Microsoft from launching the course. Please allow pop-ups for Microsoft by adding "https://microsoft.com" to your exception list and reload the page.

Access the Google Chrome menu on the toolbar. The menu on the toolbar is at the top right of your browser.
Choose settings
Find "Show advanced settings" at the bottom of the page and click it.
Under "Privacy," click on "Content settings."
Under the Pop-ups section, choose "Manage exceptions"
Add "https://microsoft.com" and set "Allow"

c# decode special characters

public string DecodeSpecial(string strVtext)
{
if (!string.IsNullOrEmpty(strVtext))
{
//strVtext=strVtext.Replace("&", "&amp;").Replace("/&", "&quot;").Replace("/'", "&apos;").Replace("<", "&lt;").Replace(">", "&gt;");
//strVtext= new System.Xml.Linq.XText(strVtext).ToString();
//strVtext=System.Web.HttpUtility.HtmlEncode(strVtext);
}
return strVtext;
}