The CASE statement goes through conditions and return a value when condition is met, from your ...
Prefixes and suffixes in field names help communicate the meaning of your field in a similar way. For example, for binary variables, variables that can only be yes or no (1 or 0), I often use the prefix “is” or the suffix “_flag”. Here are some examples: isVeteran or veteran_f...
In my previous post, I provided some sample C# code that allows you to configure SQL Server connection properties remotely through Windows Management Instrumentation. But WMI can also be used to configure client connection properties on a remote machine. Below I will provide some sample C# code to...
The first step for a solution and proper implementation of the cross-databse multiple table delete is to get rid of any ambiguities in a multiple table statement. Currently, the parser is accepting multiple table delete statements that have no obvious meaning, such as: DELETE a1 FROM db1.t1...
Yes, you are right in a sense. It might sound so overly simplified that I would like to make the description somewhat shorter. The name "Shift_JIS" can be used to refer to two different things, and the usage and semantics is often confusing. Its primary meaning is the name of a code...
In my previous post, I provided some sample C# code that allows you to configure SQL Server connection properties remotely through Windows Management Instrumentation. But WMI can also be used to configure client connection properties on a remote machine. Below I will provide some sample C# code...