Tutorial by Examples: on

Procedures, functions, triggers, and types written in .Net languages are stored in .dll files. Once you create .dll file containing CLR procedures you should import it into SQL Server: CREATE ASSEMBLY MyLibrary FROM 'C:\lib\MyStoredProcedures.dll' WITH PERMISSION_SET = EXTERNAL_ACCESS PERM...

If you have created .Net function, compiled it into .dll, and imported it into SQL server as an assembly, you can create user-defined function that references function in that assembly: CREATE FUNCTION dbo.TextCompress(@input nvarchar(max)) RETURNS varbinary(max) AS EXTERNAL NAME MyLibrary.[Nam...

Mixins can be passed a block of SASS compliant code, which then becomes available within the mixin as the @content directive. @mixin small-screen { @media screen and (min-width: 800px;) { @content; } } @include small-screen { .container { width: 600px; } } And this wou...

// 1.0 function beforeLoad(type, form, request) { nlapiLogExecution("DEBUG", "Before Load", "type=" + type); } // 2.0 /** * @NApiVersion 2.x * @NScriptType UserEventScript * @NModuleScope SameAccount */ define(["N/log"], function (log) { ...

public void Screenshot() throws Throwable{ final byte[] screenshot = ((TakesScreenshot) driver).getScreenshotAs(OutputType.BYTES); scenario.embed(screenshot, "image/png"); // ... and embed it in the report. Thread.sleep(1000); } Alternately public static void captureSc...

Range.CurrentRegion is a rectangular range area surrounded by empty cells. Blank cells with formulas such as ="" or ' are not considered blank (even by the ISBLANK Excel function). Dim rng As Range, lastCell As Range Set rng = Range("C3").CurrentRegion ' or Set rng = Shee...

#include <iostream> #include <map> #include <string> using namespace std; class A { public: map<string, string> * mapOfStrings; public: A() { mapOfStrings = new map<string, string>(); } void insertEntry(string const & key, st...

Frontend Interface /** * Entity attribute frontend interface * * Frontend is providing the user interface for the attribute * */ interface Mage_Eav_Model_Entity_Attribute_Frontend_Interface { } Source Interface /** * Entity attribute select source interface * * Source is providing ...

For Visual Studio [NuGet]: The easiest way of installing PhantomJS is by using a NuGet Package Manager. In your project, right click "References", and click on "Manage NuGet Packages" as shown: Then, type "PhantomJS" to the search bar, select it and install it as s...

The RxLifecycle library makes it easier binding observable subscriptions to Android activities and fragment lifecycle. Keep in mind that forgetting to unsubscribe an Observable can cause memory leaks and keeping your activity / fragment alive event after it has been destroyed by the system. Add th...

Decision boundary when we classify using logistic regression- Decision boundary when we classify using SVM- As it can be observed, SVM tries to maintain a 'gap' on either side of the decision boundary. This proves helpful when we encounter new data. With new data- Logistic regression perform...

This example shows how to validate forms in Spring MVC using Bean Validation API using Java Annotations, without any xml. User will be proposed to input their registration data and validator will check it for validity. Add Dependencies First of all add the following dependencies in your project: ...

Format: [command] [> | >>] [filename] > saves the output of [command] into [filename]. >> appends the output of [command] into [filename]. Examples: echo Hello World > myfile.txt saves "Hello World" into myfile.txt echo your name is %name% >> myfi...

While launching an application firstly main thread is executed. This Main thread handles all the UI concept of application. If we want to run long the task in which we don't need the UI then we use thread for running that task in background. Here is the example of Thread which describes blow: new ...

cd by itself will not allow a user to move between drives. To move to a different drive, the /d option must be specified. e.g. Moving from C:\Users\jdoe\Desktop to D:\Office Work cd /d "D:\Office Work"

In C++, looping through a sequence container c can be done using indexes as follows: for(size_t i = 0; i < c.size(); ++i) c[i] = 0; While simple, such writings are subject to common semantic errors, like wrong comparison operator, or wrong indexing variable: for(size_t i = 0; i <= c.size(...

Options are used for adding capabilities such as "User-Agent". Example in C#: var options = new PhantomJSOptions(); options.AddAdditionalCapability("phantomjs.page.settings.userAgent", "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:25.0) Gecko/20100101 Firefox/25.0&qu...

GNU awk supports a sub-string extraction function to return a fixed length character sequence from a main string. The syntax is *substr(string, start [, length ])* where, string is source string and start marks the start of the sub-string position you want the extraction to be done for an optio...

To Convert you date in dd/MM/yyyy format into milliseconds you call this function with data as String public long getMilliFromDate(String dateFormat) { Date date = new Date(); SimpleDateFormat formatter = new SimpleDateFormat("dd/MM/yyyy"); try { date = formatter.p...

Turn on Debug from menu - view > debug it return some error during start debug, show pop out notification and open launch.json from this popup notification It is just because of launch.json not set for your workspace. copy and paste below code in to launch.json //new launch.json your old lau...