Tutorial by Examples: ar

Query to search last executed sp's in db SELECT execquery.last_execution_time AS [Date Time], execsql.text AS [Script] FROM sys.dm_exec_query_stats AS execquery CROSS APPLY sys.dm_exec_sql_text(execquery.sql_handle) AS execsql ORDER BY execquery.last_execution_time DESC Query to search thro...

$Args Contains an array of the undeclared parameters and/or parameter values that are passed to a function, script, or script block. When you create a function, you can declare the parameters by using the param keyword or by adding a comma-separated list of parameters in parentheses after the...

$FirstName = 'Bob' Export-ModuleMember -Variable FirstName To export a variable from a module, you use the Export-ModuleMember command, with the -Variable parameter. Remember, however, that if the variable is also not explicitly exported in the module manifest (.psd1) file, then the variable wil...

Manage Files and Projects Ctrl+Shift+R : Open Resource (file, folder or project) Ctrl+Shift+S : Save all files Ctrl+W : Close current file Ctrl+Shift+W : Close all files Editor Window F12 : Jump to Editor Window Ctrl+E : Show list of open Editors. Use arro...

Just like PowerShell functions, workflows can accept input parameter. Input parameters can optionally be bound to a specific data type, such as a string, integer, etc. Use the standard param keyword to define a block of input parameters, directly after the workflow declaration. workflow DoSomeWork ...

workflow DoSomeWork { parallel { Get-Process -ComputerName server01 Get-Process -ComputerName server02 Get-Process -ComputerName server03 } } One of the unique features of PowerShell Workflow is the ability to define a block of activities as parallel. To use this feature, us...

type ProjectIdType = ProjectId String getProject : ProjectIdType -> Cmd Msg getProject (ProjectId id) = Http.get <| "/projects/" ++ id

Sometimes one would like to pass names of columns from a data frame to a function. They may be provided as strings and used in a function using [[. Let's take a look at the following example, which prints to R console basic stats of selected variables: basic.stats <- function(dset, vars){ f...

from nltk.tokenize import sent_tokenize, word_tokenize example_text = input("Enter the text: ") print("Sentence Tokens:") print(sent_tokenize(example_text)) print("Word Tokens:") print(word_tokenize(example_text))

Our demo app consists of a scoreboard. The score model is an immutable record. The scoreboard events are contained in a Union Type. namespace Score.Model type Score = { ScoreA: int ; ScoreB: int } type ScoringEvent = IncA | DecA | IncB | DecB | NewGame Changes are propagated by listening...

The core types in the Gjallarhorn library implement IObservable<'a>, which will make the implementation look familiar (remember the EventStream property from the FSharp.ViewModule example). The only real change to our model is the order of the arguments of the update function. Also, we now use...

SET @searchTerm= 'Database Programming'; SELECT MATCH (Title) AGAINST (@searchTerm IN NATURAL LANGUAGE MODE) Score, ISBN, Author, Title FROM book WHERE MATCH (Title) AGAINST (@searchTerm IN NATURAL LANGUAGE MODE) ORDER BY MATCH (Title) AGAINST (@searchTerm IN NATURAL LANGUA...

SET @searchTerm= 'Database Programming -Java'; SELECT MATCH (Title) AGAINST (@searchTerm IN BOOLEAN MODE) Score, ISBN, Author, Title FROM book WHERE MATCH (Title) AGAINST (@searchTerm IN BOOLEAN MODE) ORDER BY MATCH (Title) AGAINST (@searchTerm IN BOOLEAN MODE) DESC; Giv...

SET @searchTerm= 'Date Database Programming'; SELECT MATCH (Title, Author) AGAINST (@searchTerm IN NATURAL LANGUAGE MODE) Score, ISBN, Author, Title FROM book WHERE MATCH (Title, Author) AGAINST (@searchTerm IN NATURAL LANGUAGE MODE) ORDER BY MATCH (Title, Author) AGAINST (...

You cannot have more than one delimiter: if you specify something like -d ",;:", some implementations will use only the first character as a delimiter (in this case, the comma.) Other implementations (e.g. GNU cut) will give you an error message. $ cut -d ",;:" -f2 <<<&...

$ cut -d, -f1,3 <<<"a,,b,c,d,e" a,b is rather obvious, but with space-delimited strings it might be less obvious to some $ cut -d ' ' -f1,3 <<<"a b c d e" a b cut cannot be used to parse arguments as the shell and other programs do.

One of the main advantage of std::array as compared to C style array is that we can check the size of the array using size() member function int main() { std::array<int, 3> arr = { 1, 2, 3 }; cout << arr.size() << endl; }

std::array being a STL container, can use range-based for loop similar to other containers like vector int main() { std::array<int, 3> arr = { 1, 2, 3 }; for (auto i : arr) cout << i << '\n'; }

The member function fill() can be used on std::array for changing the values at once post initialization int main() { std::array<int, 3> arr = { 1, 2, 3 }; // change all elements of the array to 100 arr.fill(100); }

SWIFT: Step 1: In your Info.plist add the following attribute: View controller-based status bar appearance and set its value to NO as described in the image below: Step 2: In your AppDelegate.swift file, in didFinishLaunchingWithOptions method, add this code: UIApplication.shared.st...