Tutorial by Examples: b

CREATE TABLE all_binary_types( c_boolean boolean, c_binary binary ); Sample data: insert into all_binary_types values (0,1234); insert into all_binary_types values (1,4321); Note: For boolean, internally it stored as true or false. For binary, it will store base64 encoded value....

img{ float:left; width:100px; margin:0 10px; } .div1{ background:#f1f1f1; /* does not create block formatting context */ } .div2{ background:#f1f1f1; overflow:hidden; /* creates block formatting context */ } https://jsfiddle.net/MadalinaTn/qkwwmu6m/2/ Using the o...

HTML: <div class="wrapper"> <div class="outer"> <div class="inner"> centered </div> </div> </div> CSS: .wrapper { height: 600px; text-align: center; } .outer { display: table; ...

Redis has publish/subscribe for sending messages. This is handled by subscribing to a channel & publishing to channel. Yes, subscribers will subscribe to one or more channels. Publisher need not know who are all subscribers. Instead, publisher will publish to specific channel. All the subscriber...

Most basic Django debugging tool is pdb, a part of Python standard library. Init view script Let's examine a simple views.py script: from django.http import HttpResponse def index(request): foo = 1 bar = 0 bug = foo/bar return HttpResponse("%d goes here." % ...

The New-Object cmdlet is used to create an object. # Create a DateTime object and stores the object in variable "$var" $var = New-Object System.DateTime # calling constructor with parameters $sr = New-Object System.IO.StreamReader -ArgumentList "file path" In many instan...

New build systems can be created from the menu (Tools | Build System | New Build System). { "shell_cmd": "somecommand -u \"$file\"", "result_file_regex": "^[ ]*File \"(.*?)\"", "result_line_regex": "^[ ]*File ...

To get started with unit testing, which will be done in the tests file and will be testing the View Controller and Storyboard, we should introduce these two files to the test file. Defining the View Controller Swift var viewController : ViewController! Introducing the Storyboard and initializi...

To build up an expression like _ => _.Field == "VALUE" at runtime. Given a predicate _ => _.Field and a string value "VALUE", create an expression that tests whether or not the predicate is true. The expression is suitable for: IQueryable<T>, IEnumerable<T>...

Configuring the connection programmatically: var config = new ClientConfiguration { Servers = new List<Uri> { new Uri("http://localhost:8091/pools") }, BucketConfigs = new Dictionary<string, BucketConfiguration> ...

A spannable TextView can be used in Android to highlight a particular portion of text with a different color, style, size, and/or click event in a single TextView widget. Consider that you have defined a TextView as follows: TextView textview=findViewById(R.id.textview); Then you can apply diff...

The break operator will exit a program loop immediately. It can be used in For, ForEach, While and Do loops or in a Switch Statement. $i = 0 while ($i -lt 15) { $i++ if ($i -eq 7) {break} Write-Host $i } The above will count to 15 but stop as soon as 7 is reached. Note: When u...

Using a file Swift let data = NSData(contentsOfFile: filePath) //assuming filePath is a valid path Objective-C NSData *data = [NSData dataWithContentsOfFile:filePath]; //assuming filePath is a valid path Using a String object Swift let data = (string as NSString).dataUsingEncoding(NSUTF8S...

void methods can be stubbed using the doThrow(), doAnswer(), doNothing(), doCallRealMethod() family of methods. Runnable mock = mock(Runnable.class); doThrow(new UnsupportedOperationException()).when(mock).run(); mock.run(); // throws the UnsupportedOperationException Note thatvoid methods...

Add the I18N nuget package to your MVC project. In web.config, add the i18n.LocalizingModule to your <httpModules> or <modules> section. <!-- IIS 6 --> <httpModules> <add name="i18n.LocalizingModule" type="i18n.LocalizingModule, i18n" /> &...

Name binding is a concept that allows to say to a JAX-RS runtime that a specific filter or interceptor will be executed only for a specific resource method. When a filter or an interceptor is limited only to a specific resource method we say that it is name-bound. Filters and interceptors that do no...

var bufferBlock = new BufferBlock<int>(new DataflowBlockOptions { BoundedCapacity = 1000 }); var cancellationToken = new CancellationTokenSource(TimeSpan.FromSeconds(10)).Token; var producerTask = Task.Run(async () => { var random = new Random(); while (!cancellati...

The @switch annotation tells the compiler that the match statement can be replaced with a single tableswitch instruction at the bytecode level. This is a minor optimization that can remove unnecessary comparisons and variable loads during runtime. The @switch annotation works only for matches again...

Most KVO and KVC functionality is already implemented by default on all NSObject subclasses. To start observing a property named firstName of an object named personObject do this in the observing class: [personObject addObserver:self forKeyPath:@"firstName" ...

avg_fragmentation_in_percent valueCorrective statement>5% and < = 30%REORGANIZE>30%REBUILD ALTER INDEX IX_NonClustered ON tableName REORGANIZE; ALTER INDEX ALL ON Production.Product REBUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON, STATISTICS_NORECOMPUTE = ON);