DBCC statements act as Database Console Commands for SQL Server.
To get the syntax information for the specified DBCC command use DBCC HELP (...) statement.
The following example returns all DBCC statements for which Help is available:
DBCC HELP ('?');
The following example returns options f...
ghci> :set -XOverloadedStrings
ghci> import Data.Text as T
isInfixOf :: Text -> Text -> Bool checks whether a Text is contained anywhere within another Text.
ghci> "rum" `T.isInfixOf` "crumble"
True
isPrefixOf :: Text -> Text -> Bool checks whether a...
If you find these steps unfamiliar, consider starting here instead. Note these steps come from Stack Overflow Documentation.
django-admin startproject myproject
cd myproject
python manage.py startapp myapp
myproject/settings.py Install the app
INSTALLED_APPS = [
'django.contrib.admin',
...
Git config allows you to customize how git works. It is commonly used to set your name and email or favorite editor or how merges should be done.
To see the current configuration.
$ git config --list
...
core.editor=vim
credential.helper=osxkeychain
...
To edit the config:
$ git config <...
Abstraction is one of the main concepts in Object Oriented Programming (OOP). This is the process of hiding the implementation details for the outsiders while showing only essential details. In another words, Abstraction is a technique to arrange the complexity of a program.
There are two basic typ...
For Umbraco 7 the requirements are
IIS 7 or higher
Database, one of the following: SQL CE, SQL Server 2008 or higher or MySQL with support for case insensitive queries)
ASP.NET 4.5 or 4.5.1. Full-Trust
Ability to set file/folder permissions for the user that "owns" the Application P...
Download the files from our.umbraco.org/download and unzip them in a folder.
Set up web server hosting the folder you chose. Although IIS is a requirement for production sites, it runs fine for development in IIS Express.
Set up file permissions for the folder. For development server it is okey ...
Check for updates to the Nuget package manager. In Visual Studio: Tools > Extensions and Updates > Updates > Visual Studio Gallery. Install if availalbe
Create a new web application with template "ASP.NET Web Application with an Empty template" on .NET Framework 4.5.1
Open the...
The Memory Model is difficult to understand, and difficult to apply. It is useful if you need to reason about the correctness of multi-threaded code, but you do not want to have to do this reasoning for every multi-threaded application that you write.
If you adopt the following principals when wri...
import matplotlib.pyplot as plt
import numpy as np
# generate 1000 data points with normal distribution
data = np.random.randn(1000)
plt.hist(data)
plt.show()
A basic implementation for singly-linked-list in java - that can add integer values to the end of the list, remove the first value encountered value from list, return an array of values at a given instant and determine whether a given value is present in the list.
Node.java
package com.example.so....
To separate API logic from the component, we are creating the API client as a separate class. This example class makes a request to Wikipedia API to get random wiki articles.
import { Http, Response } from '@angular/http';
import { Injectable } from '@angular/core';
import { Observabl...
a = [1, 2, 3, 4, 5]
# steps through the list backwards (step=-1)
b = a[::-1]
# built-in list method to reverse 'a'
a.reverse()
if a = b:
print(True)
print(b)
# Output:
# True
# [5, 4, 3, 2, 1]
def shift_list(array, s):
"""Shifts the elements of a list to the left or right.
Args:
array - the list to shift
s - the amount to shift the list ('+': right-shift, '-': left-shift)
Returns:
shifted_array - the shifted list
"&quo...
USER_SOURCE describes the text source of the stored objects owned by the current user. This view does not display the OWNER column.
select * from user_source where type='TRIGGER' and lower(text) like '%order%'
ALL_SOURCE describes the text source of the stored objects accessible to the current ...
select owner, table_name
from all_tables
ALL_TAB_COLUMNS describes the columns of the tables, views, and clusters accessible to the current user. COLS is a synonym for USER_TAB_COLUMNS.
select *
from all_tab_columns
where table_name = :tname
