Tutorial by Examples: st

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...

Standard Version To install the standard version, go to the Plugin section of your WordPress installation. Search for "Advanced Custom Fields" and install/activate. You will now have access to a new area in the WordPress administrative area labeled "Custom Fields" where you can ...

<?php echo get_field('my_field_name', 123); ?> This will echo the value of "my_field_name" from the post with 123 as its ID.

<?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. ...

Fabric.js is just like any other JS library just specific to canvas. Easy to setup and get started. All you need to do is download the fabric.js from HERE and include it in your project just like any other JS library for example the way you do it for jQuery. Then create the html file suppose index.h...

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

Installation CocoaPods CocoaPods is a dependency manager for Cocoa projects. You can install it with the following command: $ gem install cocoapods CocoaPods 1.1.0+ is required to build Alamofire 4.0.0+. To integrate Alamofire into your Xcode project using CocoaPods, specify it in your Po...

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...

In mysqld.cnf or equivalent: [mysql] prompt = '\u@\h [\d]> ' This achieves a similar effect, without having to deal with .bashrc's.

<?php if( get_field('text_field') ): ?> <?php the_field('text_field'); ?> <?php endif; ?> Here we use get_field() to determine if a value exists, and the_field() to echo it.

When creating the project You should check "Include UI Tests" in the project creation dialog. After creating the project If you missed checking UI target while creating project, you could always add test target later. Setps: While project open go to File -> New -> Target Fi...

In a test you can disable animations by adding in setUp: app.launchEnvironment = ["animations": "0"] Where app is instance of XCUIApplication.

Snippet from MyExampleFile.xaml <TextBlock Foreground="{ThemeResource SystemControlBackgroundAccentBrush}" Text="This is a colored textbox that use the Accent color of your Windows 10"/> <TextBlock Foreground="{ThemeResource SystemControlBackgroundBa...

Snippet from MyExampleFile.xaml <TextBlock x:Name="MyTextBlock" Text="This is a TextBlock colored from the code behind"/> Snippet from MyExampleFile.xaml.cs // We use the application's Resource dictionary to get the current Accent of your Windows 10 ...

if( function_exists('acf_add_options_page') ) { acf_add_options_page(); } Add the above code to functions.php and an options page named 'Options' will appear in your Wordpress admin area. You now need to asign some custom fields to the page.

Performance testing is a subject/process/testing methodology but not a tool to setup. It includes the following core activities: Identify Test Environment Identify Performance Acceptance Criteria Plan and Design Tests Configure Test Environment Implement Test Design Execute Tests Analyze, ...

Create In order to perform a Create operation via REST, you must perform the following actions: Create an HTTP request using the POST verb. Use the service URL of the list to which you want to add an entity as the target for the POST. Set the content type to application/json. Serialize the JSON...