Tutorial by Examples: le

Here, a cursor is used to loop through all databases. Futhermore, a cursor from dynamic sql is used to query each database returned by the first cursor. This is to demonstrate the connection-scope of a cursor. DECLARE @db_name nvarchar(255) DECLARE @sql nvarchar(MAX) DECLARE @schema nvarcha...

SimpleXML is a powerful library which converts XML strings to an easy to use PHP object. The following assumes an XML structure as below. <?xml version="1.0" encoding="UTF-8"?> <document> <book> <bookName>StackOverflow SimpleXML Example&lt...

package main import ( "fmt" "log" "gopkg.in/mgo.v2" "gopkg.in/mgo.v2/bson" ) type Person struct { Name string Phone string } func main() { session, err := mgo.Dial("server1.example....

service I created post service with postRequest method. import {Injectable} from '@angular/core'; import {Http, Headers, Response} from "@angular/http"; import {PostModel} from "./PostModel"; import 'rxjs/add/operator/map'; import {Observable} from "rxjs"; ...

;; returns 3 (+ 1 2) ;; returns 300 (+ 50 210 40) ;; returns 2 (/ 8 4)

The DICOM Image file is a tagged image file; the file contains both an image (most of the time) and a collection of data about the image. The data in a DICOM image file is stored as a sequence of individual elements. Each element contains one item of information about the image or the image itself. ...

Installing Heroku Scheduler heroku addons:create scheduler:standard

Here's a basic example of how to do a very simple class system Class = {} local __instance = {__index=Class} -- Metatable for instances function Class.new() local instance = {} setmetatable(instance, __instance) return instance -- equivalent to: return setmetatable({}, __instance)...

app.module.ts import {routes} from "./app.routes"; @NgModule({ declarations: [AppComponent], imports: [BrowserModule, mainModule.forRoot(), RouterModule.forRoot(routes)], providers: [], bootstrap: [AppComponent] }) export class AppModule { } app.routes.t...

Let's consider the below snippet, Get-ChildItem -Path C:\MyFolder | Select-Object Name, CreationTime, Length It simply output the folder content with the selected properties. Something like, What if I want to display the file size in KB ? This is where calcualted properties comes handy. Get-...

Incorrect code Sub DoSomething() Dim foo As Collection With foo .Add "ABC" .Add "XYZ" End With End Sub Why doesn't this work? Object variables hold a reference, and references need to be set using the Set keyword. This error occurs whenever ...

you can set a Jekyll environment and value, when build time JEKYLL_ENV=production jekyll b JEKYLL_ENV=production jekyll build JEKYLL_ENV=production bundle exec jekyll build if your code contains the bellow snippet, analytics.html will not be included unless your building with JEKYLL_ENV=...

The following code illustrates how to do simple popup with Kivy. from kivy.app import App from kivy.uix.popup import Popup from kivy.lang import Builder from kivy.uix.button import Button Builder.load_string(''' <SimpleButton>: on_press: self.fire_popup() <SimplePopup>: ...

To deploy Java code to AWS Lambda, you have to create a distribution zip file that contains all dependencies that are needed during the runtime. Example project in Gradle: apply plugin: 'java' repositories { mavenCentral() } dependencies { compile 'com.amazonaws:aws-lambda-java-cor...

UITabBarController building in Swift 3 Change image color and title according to selection with changing selected tab color. import UIKit class TabbarController: UITabBarController { override func viewDidLoad() { super.viewDidLoad() self.navigationController?.isNavigat...

Set createScriptingFileSystemObject = CreateObject("Scripting.FileSystemObject") Tools> References> Microsoft Scripting Runtime Associated DLL: ScrRun.dll Source: Windows OS MSDN-Accessing Files with FileSystemObject The File System Object (FSO) model provides an object-base...

Here is a Rules example in Rules export format: { "rules_display_userpoints_after_updating_content" : { "LABEL" : "Display userpoints after updating content", "PLUGIN" : "reaction rule", "OWNER" : "rules", &qu...

public static class MyHelpers { public static MvcHtmlString MyCustomDiv(this HtmlHelper htmlHelper, string text, object htmlAttributes = null) { var mainTag = new TagBuilder("div"); mainTag.MergeAttributtes(htmlAttributes); mainTag.AddCssClas...

First create a disposable class: public class MyDisposableHelper: IDisposable { private bool _disposed; private readonly ViewContext _viewContext; public MyDisposableHelper(ViewContext viewContext) { if (viewContext == null) { throw ne...