Tutorial by Examples: d

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

Soundex

Returns a four-character code (varchar) to evaluate the phonetic similarity of two strings. Parameters: character expression. An alphanumeric expression of character data. The soundex function creates a four-character code that is based on how the character expression would sound when spoken....

Difference

Returns an integer (int) value that indicates the difference between the soundex values of two character expressions. Parameters: character expression 1. character expression 2. Both parameters are alphanumeric expressions of character data. The integer returned is the number of chars in th...

Hello World

HTML <canvas id="canvas" width=300 height=100 style="background-color:#808080;"> </canvas> Javascript var canvas = document.getElementById("canvas"); var ctx = canvas.getContext("2d"); ctx.font = "34px serif"; ctx.textAlign = &qu...

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

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

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

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

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

Semantics of typed holes

The value of a type hole can simply said to be undefined, although a typed hole triggers a compile-time error, so it is not strictly necessary to assign it a value. However, a typed hole (when they are enabled) produces a compile time error (or warning with deferred type errors) which states the nam...

Using rewrite rules on overloaded functions

In this question, @Viclib asked about using rewrite rules to exploit typeclass laws to eliminate some overloaded function calls: Mind the following class: class ListIsomorphic l where toList :: l a -> [a] fromList :: [a] -> l a I also demand that toList . fromList == id. H...

In-line DIV using float

The div is a block-level element, i.e it occupies the whole of the page width and the siblings are place one below the other irrespective of their width. <div> <p>This is DIV 1</p> </div> <div> <p>This is DIV 2</p> </div> The output of...
CSS • Floats

Creating a Seeder

To create seeders, you may use the make:seeder Artisan command. All seeders generated will be placed in the database/seeds directory. $ php artisan make:seeder MoviesTableSeeder Generated seeders will contain one method: run. You may insert data into your database in this method. <?php us...

Partially update the view

Makes an ajax request and updates only part of the view. Bean.java @ManagedBean @ViewScoped public class Bean { public Date getCurrentDate() { return new Date(); } } sample.xhtml <html xmlns="http://www.w3.org/1999/xhtml" xmlns:h="http://xmlns...

Send form parts and listen to the request

Makes a request only sending part of the form. The text1 value is set, but not text2, as the listener states. Bean.java @ManagedBean @ViewScoped public class Bean { private String text1; private String text2; public String getText1() { return text1; } pu...

Delay

Executes the requests with the specified delay in milliseconds, meaning that if any subsequent request happens after the previous has been queued, the first one will be skiped. The feature is available starting from JSF 2.2: Bean.java @ManagedBean @ViewScoped public class Bean { publi...

Automatically processing data received from a serial port

Some devices connected through a serial port send data to your program at a constant rate (streaming data) or send data at unpredictable intervals. You can configure the serial port to execute a function automatically to handle data whenever it arrives. This is called the "callback function&quo...

Page 338 of 691

logo rip
SUPPORT & PARTNERS
STAY CONNECTED

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