Tutorial by Examples: in

Find the smallest value of column: select min(age) from employee; Above example will return smallest value for column age of employee table. Syntax: SELECT MIN(column_name) FROM table_name;

Detailed instructions on getting jboss set up or installed.

DECLARE @startdate CHAR(8), @numberDays TINYINT SET @startdate = '20160101' SET @numberDays = 10; WITH CTE_DatesTable AS ( SELECT CAST(@startdate as date) AS [date] UNION ALL SELECT DATEADD(dd, 1, [date]) FROM CTE_DatesTable WHERE DATEADD(dd, 1, [date]) <= DateAdd(DAY, @nu...

Integer literals are used to provide integral values. Three numerical bases are supported, indicated by prefixes: BasePrefixExampleDecimalNone5Octal00345Hexadecimal0x or 0X0x12AB, 0X12AB, 0x12ab, 0x12Ab Note that this writing doesn't include any sign, so integer literals are always positive. Somet...

The calc() function is the part of a new syntax in CSS3 in which you can calculate (mathematically) what size/position your element occupies by using a variety of values like pixels, percentages, etc. Note:- Whenever you use this function, always take care of the space between two values calc(100% -...

XHProf is a PHP profiler originally written by Facebook, to provide a more lightweight alternative to XDebug. After installing the xhprof PHP module, profiling can be enabled / disabled from PHP code: xhprof_enable(); doSlowOperation(); $profile_data = xhprof_disable(); The returned array wil...

Currying is the technique of translating the evaluation of a function that takes multiple arguments into evaluating a sequence of functions, each with a single argument. This is normally useful when for example: different arguments of a function are calculated at different times. (Example 1) di...

To remove a variable from memory, one can use the Remove-Item cmdlet. Note: The variable name does NOT include the $. Remove-Item Variable:\foo Variable has a provider to allow most *-item cmdlets to work much like file systems. Another method to remove variable is to use Remove-Variable cmdlet...

Please read Preventing SQL injection with Parametrized Queries for a complete discussion of why prepared statements help you secure your SQL statements from SQL Injection attacks The $conn variable here is a MySQLi object. See MySQLi connect example for more details. For both examples, we assume t...

Giving this enumeration as Example: enum Compass { NORTH(0), EAST(90), SOUTH(180), WEST(270); private int degree; Compass(int deg){ degree = deg; } public int getDegree(){ return degree; } } In Java an enum class is like any other c...

In /res/values/strings.xml: <string-array name="spinner_options"> <item>Option 1</item> <item>Option 2</item> <item>Option 3</item> </string-array> In layout XML: <Spinner android:id="@+id/spinnerName" ...

Direct Download - download link CDN - get here Bower - bower install bootstrap [read] NPM - npm install bootstrap [read] Composer - composer require twbs/bootstrap [read] Customize - I you have your own config, you can customize here. Sass - For Sass related projects you may get it here. ...

How do you go about using an instance of a (possibly further) inherited generic type within a method declaration in the generic type itself being declared? This is one of the problems you will face when you dig a bit deeper into generics, but still a fairly common one. Assume we have a DataSeries&l...

apologies: since I don't know of a channel for discussing/providing feedback on requests for improvement, I'm going to put my question here. Please feel free to point out a better place for this! @DataTx states that this is "completely unclear, incomplete, or has severe formatting problems&quot...

A texture is a form of data storage that allows convenient access not just to particular data entries, but also to sample points mixing (interpolating) multiple entries together. In OpenGL textures can be used for many things, but most commonly it's mapping an image to a polygon (for example a tria...

To enable Second Level Caching for Hibernate in WildFly, add this property to your persistence.xml file: <property name="hibernate.cache.use_second_level_cache" value="true"/> You may also enable Query Caching with this property: <property name="hibernate.cache...

$user = User::find(1); $user->name = 'abc'; $user->save(); You can also update multiple attributes at once using update, which does not require using save afterwards: $user = User::find(1); $user->update(['name' => 'abc', 'location' => 'xyz']); You can also update a model(s)...

DataObjects in SilverStripe represent a database table row. The fields in the model have magic methods that handle getting and setting data via their property names. Given we have a simple DataObject as an example: class Fruit extends DataObject { private static $db = ['Name' => 'Varchar'...

Assuming this HTML in the page: <body> <div id="myPage"> </div> </body> A view can be bound to it with: var MyPageView = Backbone.View.extend( { "el": "#myPage", "template": _.template( "<p>This is m...

initialize is called by Backbone right after a View is constructed. Optional parameters The initialize function receives any arguments passed to the view's constructor. Commonly, the options hash that is used to pass the view's default options: ['model', 'collection', 'el', 'id', 'attributes', 'c...