Tutorial by Examples: nd

Index hints are used to force a query to use a specific index, instead of allowing SQL Server's Query Optimizer to choose what it deems the best index. In some cases you may gain benefits by specifying the index a query must use. Usually SQL Server's Query Optimizer chooses the best index suited for...

var sourceFileName = "NonExistingFile"; try { System.IO.File.Copy(sourceFileName, "DestinationFile"); } catch (Exception e) { var stdErr = Console.Error; stdErr.WriteLine($"Failed to copy '{sourceFileName}': {e.Message}"); }

var errors = new System.Text.StringBuilder(); var process = new Process { StartInfo = new ProcessStartInfo { RedirectStandardError = true, FileName = "xcopy.exe", Arguments = "\"NonExistingFile\" \"DestinationFile\"", ...

To get the list of Elixir modules just type h Elixir.[TAB] Pressing [TAB] autocompletes modules and functions names. In this case it lists all modules. To find all functions in a module e.g. List use h List.[TAB]

For rendering multiple props or variables we can use ``. render() { let firstName = 'test'; let lastName = 'name'; return ( <View style={styles.container}> <Text>{`${firstName} ${lastName}` } </Text> </View> ); } Output: te...

php -S localhost:80 -t project/public router.php PHP 7.1.7 Development Server started at Fri Jul 14 15:22:25 2017 Listening on http://localhost:80 Document root is /home/project/public Press Ctrl-C to quit.

The PXDBDateAndTime attribute and the PXDateAndTime attribute are designed to work with a DAC field of the Nullable<DateTime> (DateTime?) type and store both date and time value parts inside a single field: #region UsrDateAndTime public abstract class usrDateAndTimeAttribute : IBqlField { }...

HTML <p>This is a nice </p> <p>I like </p> <ul> <li>List item 1</li> <li>List item 2</li> <li>List item 3</li> </ul> <button id="btn-1">Append text</button> <button id="btn-2&quot...

The RelayCommand implements the ICommand interface and can therefore be used to bind to Commands in XAML (as the Command property of the Button element) The constructor takes two arguments; the first is an Action which will be executed if ICommand.Execute is called (e.g. the user clicks on the butt...

The RelayCommand<T> is similar to the RelayCommand, but allows to directly pass an object to the command. It implements the ICommand interface and can therefore be used to bind to Commands in XAML (e.g. as the Command property of the Button element). You can then use the CommandParameter prope...

One can use the command-line launching facility is when one wants to customize some aspects of the way MySQL Workbench operates. MySQL Workbench has the following common command line options: --admin instance - Launch MySQL Workbench and load the server instance specified. --query connection - ...

Here i will show you how to fetch All parent(configuarble products) A parent product and all of its children.

Here we first fetch our parent product and the we will get all children products that this parent have. <?php namespace Test\Test\Controller\Test; use Magento\Framework\App\Action\Context; class Products extends \Magento\Framework\App\Action\Action { public function __cons...

Arrays values should be accessed using a number specifying the location of the desired value in the array. This number is called Index. Indexes starts at 0 and finish at array length -1. To access a value, you have to do something like this: arrayName[index], replacing "index" by the num...

I have read and watched a lot of different Dagger2 tutorials but most of them are too long or hard to understand so I decided to write a new simple and short tutorial for Dagger2, I hope you like it. Why we need it? Simplifies access to shared instances: It provides a simple way to obtain refere...

var myArray = []; // empty array An array is a set of variables. For example: var favoriteFruits = ["apple", "orange", "strawberry"]; var carsInParkingLot = ["Toyota", "Ferrari", "Lexus"]; var employees = ["Billy", "Bob...

Let's first brush up with what are the Instance Variables: They behave more like properties for an object. They are initialized on an object creation. Instance variables are accessible through instance methods. Per Object has per instance variables. Instance Variables are not shared between object...

Rhas a vast collection of built-in datasets. Usually, they are used for teaching purposes to create quick and easily reproducible examples. There is a nice web-page listing the built-in datasets: https://vincentarelbundock.github.io/Rdatasets/datasets.html Example Swiss Fertility and Socioecono...

Numerous packages are created specifically to access some databases. Using them can save a bunch of time on reading/formating the data. Eurostat Even though eurostat package has a function search_eurostat(), it does not find all the relevant datasets available. This, it's more convenient to brow...

An entity represents an object of a game like a player figure or an enemy figure. Since this object does not do much without arms and legs we can add the components to this. To create this system apple has the GKEntity and GKComponent classes. Lets assume we have the following classe for the follow...