Month: July 2019

Seamless Integration

Pattern Matching in C# Switch

Switch…Case block is used to provide handling of flow of the program logic based on certain outcome of a variable. Most of the time, we evaluate the variable and depending on exact match, we pass the flow to a case handler like this: switch (color) { case “Red”: gotoRedHandler(); break; case “Green”: gotoGreenHandler(); break; default: …

SQL Server Management Studio (SSMS) – Save changes made to a Table

SSMS will prevent any changes being made to the table through the ‘Design’ mode: You will see the following error appear that prompts us to drop and re-create table: This restriction is set by SSMS from accidental changes on the table structure. However, if you are certain the changes are intended, you can overcome this …