Tutorial by Examples: a

Send simple email

This code sends a simple text-only email to [email protected] EXEC msdb.dbo.sp_send_dbmail @profile_name = 'The Profile Name', @recipients = '[email protected]', @body = 'This is a simple email sent from SQL Server.', @subject = 'Simple email'

Send results of a query

This attaches the results of the query SELECT * FROM Users and sends it to [email protected] EXEC msdb.dbo.sp_send_dbmail @profile_name = 'The Profile Name', @recipients = '[email protected]', @query = 'SELECT * FROM Users', @subject = 'List of users', ...

Send HTML email

HTML content must be passed to sp_send_dbmail SQL Server 2012 DECLARE @html VARCHAR(MAX); SET @html = CONCAT ( '<html><body>', '<h1>Some Header Text</h1>', '<p>Some paragraph text</p>', '</body></html>' ) SQL Server 2012 ...

Format

SQL Server 2012 Returns a NVARCHAR value formatted with the specified format and culture (if specified). This is primarily used for converting date-time types to strings. Parameters: value. An expression of a supported data type to format. valid types are listed below. format. An NVARCHAR form...

Low-Variance Feature Removal

This is a very basic feature selection technique. Its underlying idea is that if a feature is constant (i.e. it has 0 variance), then it cannot be used for finding any interesting patterns and can be removed from the dataset. Consequently, a heuristic approach to feature elimination is to first re...

Trailing return type

auto is used in the syntax for trailing return type: auto main() -> int {} which is equivalent to int main() {} Mostly useful combined with decltype to use parameters instead of std::declval<T>: template <typename T1, typename T2> auto Add(const T1& lhs, const T2& rh...
C++ • auto

Order of initialization of globals across TU

Whereas inside a Translation Unit, order of initialization of global variables is specified, order of initialization across Translation Units is unspecified. So program with following files foo.cpp #include <iostream> int dummyFoo = ((std::cout << "foo"), 0); b...

Creating an Interval Iterating System

A simple EntitySystem that processes a Family of entities not once per frame, but after a given interval. Entity processing logic should be placed in processEntity(Entity). For more info, please see IntervalIteratingSystem In the below code example, the best usage for this is the physics world ...

Ways to circumvent Same-Origin Policy

As far as client-side JavaScript engines are concerned (those running inside a browser), there is no straightforward solution available for requesting content from sources other than the current domain. (By the way, this limitation does not exist in JavaScript-server tools such as Node JS.) However...

Controlling the playback using SoundEffectInstance

SoundEffect.Play() plays the sound effect in a "fire-and-forget" fashion. The sound plays once and its lifetime is managed by the framework. You are not able to change the properties (volume, pan, pitch) of the sound during playback, loop it, position it in 3D or pause it. You can hold a ...

Installation or Setup

Google Sheets is a spreadsheet application that runs on web browser. It doesn't require any installation or setup just a Google account and a modern web browser.

Installation or Setup

Detailed instructions on getting outlook-addin set up or installed.

Using the Gradle Wrapper behind a proxy

The first time a user runs a project's gradlew, it should be realized that it will do two key things: Check to see if the version of the gradle used by the wrapper is already in ~/.gradle/wrapper/dists If not, download the archive of the version from the internet If you're in an environment t...

Correctly appending an SVG element

This is a relatively common mistake: You created an rect element, in a bar chart for instance, and you want to add a text label (let's say, the value of that bar). So, using the same variable that you used to append the rect and define its x and y position, you append your text element. Very logic, ...

Tensorflow Basics

Tensorflow works on principle of dataflow graphs. To perform some computation there are two steps: Represent the computation as a graph. Execute the graph. Representation: Like any directed graph a Tensorflow graph consists of nodes and directional edges. Node: A Node is also called an Op(s...

pushd/popd (store current dir on stack and go to dest / pop prev dir and go to it)

$ pwd /home/bob/somedir1/somedir2/somedir3 $ pushd /home/bob/otherdir1/otherdir2 /home/bob/otherdir1/otherdir2 /home/bob/somedir1/somedir2/somedir3 $ popd /home/bob/somedir1/somedir2/somedir3 $ pushd /usr /usr /home/bob/somedir1/somedir2/somedir3 $ pushd /var /var /usr /home/bob/som...

Repeat a String

6 This can be done using the .repeat() method: "abc".repeat(3); // Returns "abcabcabc" "abc".repeat(0); // Returns "" "abc".repeat(-1); // Throws a RangeError 6 In the general case, this should be done using a correct polyfill for the ES6...

Normal forms

This example provides a brief overview - for a more in-depth explanation of normal forms and examples, see this question. Reduced normal form The reduced normal form (or just normal form, when the context is clear) of an expression is the result of evaluating all reducible subexpressions in the gi...

Function compositions with multiple channels

Arrow is, vaguely speaking, the class of morphisms that compose like functions, with both serial composition and “parallel composition”. While it is most interesting as a generalisation of functions, the Arrow (->) instance itself is already quite useful. For instance, the following function: sp...

Syntax of typed holes

A typed hole is a single underscore (_) or a valid Haskell identifier which is not in scope, in an expression context. Before the existance of typed holes, both of these things would trigger an error, so the new syntax does not interfere with any old syntax. Controlling behaviour of typed holes Th...

Page 547 of 1099

logo rip
SUPPORT & PARTNERS
STAY CONNECTED

Get monthly updates about new articles, cheatsheets, and tricks.