Tutorial by Examples: w

Create example table Employee: CREATE TABLE Employee ( Id INT, EmpName VARCHAR(25), EmpGender VARCHAR(6), EmpDeptId INT ) Creates stored procedure that checks whether the values passed in stored procedure are not null or non empty and perform insert operation in Employee ta...
Open a Command Prompt window and run the following commands: adb kill-server set ADB_TRACE=sockets adb nodaemon server 2>&1 | for /f "usebackq tokens=7*" %a in (`findstr /c:"): '"`) do @echo %a %b >> %USERPROFILE%\Desktop\adb_host_log.txt Now you can run your A...
Unit tests are declared in the test/runtests.jl file in a package. Typically, this file begins using MyModule using Base.Test The basic unit of testing is the @test macro. This macro is like an assertion of sorts. Any boolean expression can be tested in the @test macro: @test 1 + 1 == 2 @test...
0.5.0 In version v0.5, test sets are built into the standard library Base.Test module, and you don't have to do anything special (besides using Base.Test) to use them. 0.4.0 Test sets are not part of Julia v0.4's Base.Test library. Instead, you have to REQUIRE the BaseTestNext module, and add u...
You can see list with all environment variables with: Get-Childitem env:
#requires -version 4 After trying to run this script in lower version, you will see this error message .\script.ps1 : The script 'script.ps1' cannot be run because it contained a "#requires" statement at line 1 for Windows PowerShell version 5.0. The version required by the script do...
Google Analytics is used to track user activity on your website or mobile application. To set up google-analytics on a website you will need to get a snippet of JavaScript code from Google that you embed in the head of each page on your site that you want to track user activity. Get the code snipp...
Consider these two pieces of code: int a = 1000; int b = a + 1; and Integer a = 1000; Integer b = a + 1; Question: Which version is more efficient? Answer: The two versions look almost the identical, but the first version is a lot more efficient than the second one. The second version is...
In order to begin using WebRTC you need to get camera and microphone permission.For that you need following things: adapter.js, you can get it from here A html webpage with a video tag and little bit of js code The adapter.js is a JavaScript shim for WebRTC, maintained by Google with help fro...
Paste this code into an empty HTML file and run it in your browser. <!DOCTYPE html> <body> <script src="https://d3js.org/d3.v4.js"></script> <!-- This downloads d3 library --> <script> //This code will visualize a data set as a simple scatt...
when can be used to match enum values: enum class Day { Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday } fun doOnDay(day: Day) { when(day) { Day.Sunday -> // Do something Day.Monday, Day.Tuesday -> // Do oth...
The NSTimeInterval value of this property indicates the seconds from which the date picker in countdown-timer mode counts down. If the mode of the date picker is not CountDownTimer, this value is ignored. Maximum value is 86,399 seconds (23:59) let datePicker = UIDatePicker(frame: CGRect(x: 0, y: 0...
You can access online help documentation using: Get-Help Get-Command -Online
Show usage examples for a specific cmdlet. Get-Help Get-Command -Examples
View the full documentation for the topic. Get-Help Get-Command -Full
This code uses the top level Application object to minimize the main Excel window. Sub MinimizeExcel() Application.WindowState = xlMinimized End Sub
You can view help for a specific parameter using: Get-Help Get-Content -Parameter Path
Private Sub Get_Last_Used_Row_Index() Dim wS As Worksheet Set wS = ThisWorkbook.Sheets("Sheet1") Debug.Print LastCol_1(wS) Debug.Print LastCol_0(wS) End Sub You can choose between 2 options, regarding if you want to know if there is no data in the worksheet :...
The simplest way to refer to a single cell on the current Excel worksheet is simply to enclose the A1 form of its reference in square brackets: [a3] = "Hello!" Note that square brackets are just convenient syntactic sugar for the Evaluate method of the Application object, so technicall...

Page 175 of 319