Tutorial by Examples: v

If a view is created WITH SCHEMABINDING, the underlying table(s) can't be dropped or modified in such a way that they would break the view. For example, a table column referenced in a view can't be removed. CREATE VIEW dbo.PersonsView WITH SCHEMABINDING AS SELECT name, address FROM d...

Maybe Maybe is an applicative functor containing a possibly-absent value. instance Applicative Maybe where pure = Just Just f <*> Just x = Just $ f x _ <*> _ = Nothing pure lifts the given value into Maybe by applying Just to it. The (<*>) function applies...

//Using File.WriteAllBytes using (ExcelPackage excelPackage = new ExcelPackage()) { //create a new Worksheet ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("Sheet 1"); //add some text to cell A1 worksheet.Cells["A1"].Value = "My secon...

//Using File.WriteAllBytes using (ExcelPackage excelPackage = new ExcelPackage()) { //create a new Worksheet ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("Sheet 1"); //add some text to cell A1 worksheet.Cells["A1"].Value = "My fourt...

File: /etc/resolv.conf contains a list of DNS servers for domain name resolution Sample contents of the file: nameserver 8.8.8.8 # IP address of the primary name server nameserver 8.8.4.4 # IP address of the secondary name server In case internal DNS server you can validate if this server reso...

Sometimes the crashes occur constantly in a single form or report, or occur only when printing. It is possible that the binary data within the form / report has become corrupt. Save the Form / Report object as text There are two undocumented functions. Application.SaveAsText and Application.Load...

If you have images or other data stored in Access itself as OLE Objects, then you should find a better approach. When the OLE data is stored, it is stored according to the software (and version of software) on the computer storing it. When another computer goes to display that OLE Object data on the...

This is a sample Fastfile setup for a multi-flavor app. It gives you an option to build and deploy all flavors or a single flavor. After the deployment, it reports to Slack the status of the deployment, and sends a notification to testers in Beta by Crashlytics testers group. To build and deploy al...

While using laravel pagination you are free to use your own custom views.So,when calling the links method on a paginator instance, pass the view name as the first argument to the method like : {{ $paginator->links('view.name') }} or You can customize the pagination views is by exporting the...

<?php $visit = 1; if(file_exists("counter.txt")) { $fp = fopen("counter.txt", "r"); $visit = fread($fp, 4); $visit = $visit + 1; } $fp = fopen("counter.txt", "w"); fwrite($fp, $visit); echo "Total Site Visits: &qu...

Good video tutorials about Emacs can be found at emacsrocks.com.

Using the EventFiringWebDriver. You can attach WebDriverEventListener to it and override methodes, ie the onException method: EventFiringWebDriver driver = new EventFiringWebDriver(new FirefoxDriver()); WebDriverEventListener listener = new AbstractWebDriverEventListener() { @Override pu...

Add this lane to your Fastfile and run fastlane installAll type:{BUILD_TYPE} in command line. Replace BUILD_TYPE with the build type you want to build. For example: fastlane installAll type:Debug This command will build all flavors of given type and install it to your device. Currently, it doesn't...

A vector is essentially a pointer to a heap-allocated, dynamically-sized list of objects of a single type. Example fn main() { // Create a mutable empty vector let mut vector = Vec::new(); vector.push(20); vector.insert(0, 10); // insert at the beginning println!(&qu...

If oDic.Exists("UK") Then oDic.remove("UK") End If

If you do not want to use ASPNETCORE_ENVIRONMENT from environment variables and use it from web.config of your application then modify web.config like this- <aspNetCore processPath=".\WebApplication.exe" arguments="" stdoutLogEnabled="false" stdoutLogFile=".\lo...

We can create a service to set and get the data between the controllers and then inject that service in the controller function where we want to use it. Service : app.service('setGetData', function() { var data = ''; getData: function() { return data; }, setData: function(requestData)...

There are a lot of good video tutorials for the AngularJS framework on egghead.io https://egghead.io/courses/angularjs-app-from-scratch-getting-started https://egghead.io/courses/angularjs-application-architecture https://egghead.io/courses/angular-material-introduction https://egghead.io/co...

Create a sample table on a sample database CREATE TABLE [dbo].[Table_1]( [Id] [int] IDENTITY(1,1) NOT NULL, [title] [varchar](50) NULL, CONSTRAINT [PK_Table_1] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_...

① the concepts used in this Example : ClassUsageURLRequest + Loader + EventLoading atlas map (sprite) from external path.BitmapData + Sprite + beginBitmapFill +Matrix + stageWidth & stageHeightdrawing loaded resources to bitmapdata, using tiled bitmaps, drawing with transformation.MovieClip + s...