Tutorial by Examples: c

update <SCHEMA_NAME>.<TABLE_NAME_1> AS A SET <COLUMN_1> = True FROM <SCHEMA_NAME>.<TABLE_NAME_2> AS B WHERE A.<COLUMN_2> = B.<COLUMN_2> AND A.<COLUMN_3> = B.<COLUMN_3>

Monthwise difference between two dates(timestamp) select ( (DATE_PART('year', AgeonDate) - DATE_PART('year', tmpdate)) * 12 + (DATE_PART('month', AgeonDate) - DATE_PART('month', tmpdate)) ) from dbo."Table1" Yearwise difference between two dates...

Conditions: package should be at least installed. If not loaded in the current session, not a problem. ## Checking package version which was installed at past or ## installed currently but not loaded in the current session packageVersion("seqinr") # [1] ‘3.3.3’ packageVer...

To check the list of loaded packages search() OR (.packages())

A frequent reason why your read operation may not work is because your security rules reject the operation, for example because you're not authenticated (by default a database can only be accessed by an authenticated user). You can see these security rule violations in the Console output. But it's ...

The following table compares the features available(1) in EF Core and EF6.x. It is intended to give a high level comparison and does not list every feature, or attempt to give details on possible differences between how the same feature works. Creating a ModelEF6.xEF Core 1.0.0Basic modelling (cla...

<?php if( get_field('my_field_name') ){ ?> <?php echo get_field('my_field_name'); ?> <?php }; ?> This will only show the field if content exists depending on content type (i.e., an image is uploaded to the field, text is entered, it is selected, etc.).

A typical payment flow with Stripe can be divided in two steps: Client-side, in your frontend (HTML + Javascript) code, you collect the customer's payment information using Stripe's prebuilt Checkout form or Elements form field(s). This will return a token that you then send to your server. ...

WKWebView resizes the fonts on web content so that a full-sized web page will fit on the device's form factor. If you want the web text in both portrait and landscape to be similar in size to the user's preferred reading size, you need to set it explicitly. Swift // build HTML header for dynamic t...

Using java.lang.Runnable we make our "Hello World!" example available to Java users with versions dating all the way back to the 1.2 release: import javax.swing.JFrame; import javax.swing.SwingUtilities; import javax.swing.WindowConstants; public class Main { public static void ...

Dim cars(2) cars(0) = "Ford" cars(1) = "Audi" cars(2) = "Prius"

Dim cars() Redim cars(0) 'Give it 1 entry Dim tmp tmp = "Ford" 'ubound(arrayvariable) is the count of array size. 'in this case, it would be 1, since there is 1 entry. cars(ubound(cars)) = tmp 'cars(0) Redim preserve cars(ubound(cars)+1)

Dim cars Dim filefullname : filefullname = "C:\testenv\test.txt" 'If you can, create an instaneous read for text file data for better memory handling. 'Unless it's a large file and that's impossible. cars = Split(CreateObject("Scripting.FileSystemObject").OpenTextFile(filefu...

You cannot alter the array's contents through the loop variable because it's a temporary each element is being assigned to. Dim cars(2) 'collection of different cars Dim trace 'track iteration details cars(0) = "Ford" cars(1) = "Audi" cars(2) = "Prius" For Each ca...

First Execute CREATE EXTENSION DBLINK; Then INSERT INTO <SCHEMA_NAME>.<TABLE_NAME_1> SELECT * FROM DBLINK( 'HOST=<IP-ADDRESS> USER=<USERNAME> PASSWORD=<PASSWORD> DBNAME=<DATABASE>', 'SELECT * FROM <SCHEMA_NAME>.<TABLE_NAME_2...

A very useful and logical follow-up to histograms and density plots would be the Empirical Cumulative Distribution Function. We can use the function ecdf() for this purpose. A basic plot produced by the command plot(ecdf(rnorm(100)),main="Cumulative distribution",xlab="x") wo...

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); class Cron extends CI_Controller { /** * This is default constructor of the class */ public function __construct() { parent::__construct(); $this->load->library('input'...

In application/hooks folder, create a file with name Blocker.php and paste the below code. <?php class Blocker { function Blocker(){ } /** * This function used to block the every request except allowed ip address */ function requestBlocker(){ ...

Android supports fingerprint api from Android 6.0 (Marshmallow) SDK 23 To use this feature in your app, first add the USE_FINGERPRINT permission in your manifest. <uses-permission android:name="android.permission.USE_FINGERPRINT" /> Here the procedure to follow ...

Apache JMeter segregated all the components into following groups based on their functionality: Test Plan: Starting point for scripting. JMeter saves the Test Plan in .jmx format. You add components to the Test Plan by Right Click on the Test Pand and navigating to the component you want to add. ...