DBCC commands enable user to validate state of database.
ALTER TABLE Table1 WITH NOCHECK ADD CONSTRAINT chkTab1 CHECK (Col1 > 100);
GO
DBCC CHECKCONSTRAINTS(Table1);
--OR
DBCC CHECKCONSTRAINTS ('Table1.chkTable1');
Check constraint is added with nocheck options, so it will not be ...
DBCC commands can show information about database objects.
DBCC PROCCACHE
Displays information in a table format about the procedure cache.
DBCC OUTPUTBUFFER ( session_id [ , request_id ])
Returns the current output buffer in hexadecimal and ASCII format for the specified session_id (and o...
follow below step to add FCM in your swift Project
1- If you don't have an Xcode project yet, create one now.
Create a Podfile if you don't have one:
$ cd your-project directory
$ pod init
2- Add the pods that you want to install. You can include a Pod in your Podfile like this:
pod 'Fir...
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...
Use an ensure clause if there is code you always want to execute.
def divide(x, y)
begin
z = x/y
return z
rescue ZeroDivisionError
puts "Don't divide by zero!"
rescue TypeError
puts "Division only works on numbers!"
return nil
rescue => e
...
As with everything in Windows Azure, You have to have a Windows Azure account and an Azure Subscription. After you have both, go to https://portal.azure.com. From here, you can add new resources to your Azure subscription.
Click New on the left menu.A new blade will be added to the right of you...
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...
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
ObservableCollection is a collection of type T like List<T> which means that it holds objects of type T.
From documentation we read that :
ObservableCollectionrepresents a dynamic data collection that
provides notifications when items get added, removed, or when the
entire list is refres...
To use the IMAP functions in PHP you'll need to install the IMAP extension:
Debian/Ubuntu with PHP5
sudo apt-get install php5-imap
sudo php5enmod imap
Debian/Ubuntu with PHP7
sudo apt-get install php7.0-imap
YUM based distro
sudo yum install php-imap
Mac OS X with php5.6
brew reinsta...
Once you've connected to your mailbox, you'll want to take a look inside. The first useful command is imap_list. The first parameter is the resource you acquired from imap_open, the second is your mailbox string and the third is a fuzzy search string (* is used to match any pattern).
$folders = ima...
Passing ByRef or ByVal indicates whether the actual value of an argument is passed to the CalledProcedure by the CallingProcedure, or whether a reference (called a pointer in some other languages) is passed to the CalledProcedure.
If an argument is passed ByRef, the memory address of the argument i...
let bodies = (contact.bodyA.categoryBitMask <= contact.bodyB.categoryBitMask) ? (A:contact.bodyA,B:contact.bodyB) : (A:contact.bodyB,B:contact.bodyA)
switch (bodies.A.categoryBitMask,bodies.B.categoryBitMask)
{
case let (a, _) where (a && superPower): //All we care about is i...
First of all, install gulp and gulp-jsdoc3 to your project:
npm install gulp-jsdoc3 --save-dev
Then add it to your gulpfile.js
var gulp = require('gulp');
var jsdoc = require('gulp-jsoc3');
gulp.task('doc', function (cb){
gulp.src('src/*.js')
.pipe(jsdoc(cb));
});
In order...