Tutorial by Examples: s

Use of global variables is generally discouraged. It makes your program more difficult to understand, and harder to debug. But sometimes using a global variable is acceptable. global.h #ifndef GLOBAL_DOT_H /* This is an "include guard" */ #define GLOBAL_DOT_H /** * This tells ...
Basic usage: PropertyInfo prop = myInstance.GetType().GetProperty("myProperty"); // get the value myInstance.myProperty object value = prop.GetValue(myInstance); int newValue = 1; // set the value myInstance.myProperty to newValue prop.setValue(myInstance, newValue); Setting rea...

SUM

Sum function sum the value of all the rows in the group. If the group by clause is omitted then sums all the rows. select sum(salary) TotalSalary from employees; TotalSalary2500 select DepartmentId, sum(salary) TotalSalary from employees group by DepartmentId; DepartmentIdTotalSalary12000...
While static constructors are always called before the first usage of a type it's sometimes useful to be able to force them to be called and the RuntimeHelpers class provide an helper for it: using System.Runtime.CompilerServices; // ... RuntimeHelpers.RunClassConstructor(typeof(Foo).TypeHand...
To prepare your web site or web application to use Kendo UI, simply add the style and script files in the <head> section of your page. CDN services are provided for the minified versions of official Kendo UI releases, for both HTTP and HTTPS protocols. JQuery is also required to use Kendo UI...
What is a Singleton Class? A singleton class returns the same instance no matter how many times an application requests it. Unlike a regular class, A singleton object provides a global point of access to the resources of its class. When to Use Singleton Classes? Singletons are used in situations ...
This example use the default boxplot() function and the irisdata frame. > head(iris) Sepal.Length Sepal.Width Petal.Length Petal.Width Species 1 5.1 3.5 1.4 0.2 setosa 2 4.9 3.0 1.4 0.2 setosa 3 4.7 3.2 ...
First install Mono by going through the install instructions for the platform of your choice as described in their installation section. Mono is available for Mac OS X, Windows and Linux. After installation is done, create a text file, name it HelloWorld.cs and copy the following content into it: ...
ALTER TABLE Employees DROP CONSTRAINT DefaultSalary This Drops a constraint called DefaultSalary from the employees table definition. Note:- Ensure that constraints of the column are dropped before dropping a column.
ALTER TABLE Employees ADD CONSTRAINT DefaultSalary DEFAULT ((100)) FOR [Salary] This adds a constraint called DefaultSalary which specifies a default of 100 for the Salary column. A constraint can be added at the table level. Types of constraints Primary Key - prevents a duplicate record in...
A common pattern in C, to easily imitate returning multiple values from a function, is to use pointers. #include <stdio.h> void Get( int* c , double* d ) { *c = 72; *d = 175.0; } int main(void) { int a = 0; double b = 0.0; Get( &a , &b ); pr...
Executable File Download the .exe from http://dev.sitecore.net/ and double-click to start. This .exe will do everything for you - attach databases, modify host file, and set folder permissions. The only downside is that it leaves an entry in the registry under [HKEY_LOCAL_MACHINE\SOFTWARE\Sitecore...
The String.Join method will help us to construct a string From array/list of characters or string. This method accepts two parameters. The first one is the delimiter or the separator which will help you to separate each element in the array. And the second parameter is the Array itself. String from...
Usually we are using String.Format method for formatting purpose, the.ToString is usually used for converting other types to string. We can specify the format along with the ToString method while conversion is taking place, So we can avoid an additional Formatting. Let Me Explain how it works with d...
A cross join is a Cartesian join, meaning a Cartesian product of both the tables. This join does not need any condition to join two tables. Each row in the left table will join to each row of the right table. Syntax for a cross join: SELECT * FROM table_1 CROSS JOIN table_2 Example: /* Sample...
Enums can define abstract methods, which each enum member is required to implement. enum Action { DODGE { public boolean execute(Player player) { return player.isAttacking(); } }, ATTACK { public boolean execute(Player player) { re...
Setting a default value can be done by using Initializers (C#6) public class Name { public string First { get; set; } = "James"; public string Last { get; set; } = "Smith"; } If it is read only you can return values like this: public class Name { pu...
To start development with Elm, you need to install a set of tools called elm-platform. It includes: elm-make, elm-reactor, elm-repl and elm-package. All of these tools are available through CLI, in other words you can use them from your terminal. Pick one of the following methods to install Elm: ...
This example aims to describe how one can utilize git rebase in interactive mode. It is expected that one has a basic understanding of what git rebase is and what it does. Interactive rebase is initiated using following command: git rebase -i The -i option refers to interactive mode. Using inte...
Working in old browsers (IE >= 8) Automatic margins, paired with values of zero for the left and right or top and bottom offsets, will center an absolutely positioned elements within its parent. View Result HTML <div class="parent"> <img class="center" src=&quo...

Page 96 of 1057