Check Key Constraints => CK_ParentTable_Column
E.g.: CK_Employee_EmployeeId
Default Key Constraints => DF_ParentTable_Column
E.g.: DF_Employee_EmployeeId
Foreign Key Constraints => FK_ParentTable_ChildTable_Column
E.g.: FK_Employee_Job_EmployeeId
Primary Key Constraints => PK_ParentTable_Column
E.g.: PK_Employee_EmployeeId
Unique Key Constraints => IX_ParentTable_Column
E.g.: IX_Employee_Email
CREATE TABLE SYNTAX
CREATE TABLE employee (
EmployeeId INT NOT NULL IDENTITY(1, 1),
FirstName VARCHAR(255),
LastName VARCHAR(255),
Email VARCHAR(255) CONSTRAINT IX_Employee_Email UNIQUE
)
ALTER TABLE SYNTAX
ALTER TABLE employee
ADD CONSTRAINT IX_Employee_Email UNIQUE(Email)
For more info on constraints and constraint naming please refer to the following links:
http://msdn.microsoft.com/en-us/library/ms174979.aspx
http://blog.sqlauthority.com/2007/02/05/sql-server-primary-key-constraints-and-unique-key-constraints/
http://msdn.microsoft.com/en-us/library/ms177420.aspx
Tuesday, June 21, 2011
Monday, May 16, 2011
Wednesday, January 26, 2011
Friday, January 7, 2011
Google Apps made easy
There is a nice way of using Google Mail and Calendar if you are using Chrome as a browser.
Step 1.
Install Chrome (if you have not yet... you probably cannot... or no one has told you how much better it is)
Step 2.
Download this and install this little application.
http://dl.google.com/tag/s/ap=mydomain.com/googlewebapps/en/googleappsstandalonesetuptagged.exe
You are done!
What you get is a separate window for your Email and Calendar.., which makes life so much easier...
Once you run this.. it looks like this:
And it looks like this:
Credit goes to Gerhard Pretorius for this useful post.
Step 1.
Install Chrome (if you have not yet... you probably cannot... or no one has told you how much better it is)
Step 2.
Download this and install this little application.
http://dl.google.com/tag/s/ap=mydomain.com/googlewebapps/en/googleappsstandalonesetuptagged.exe
You are done!
What you get is a separate window for your Email and Calendar.., which makes life so much easier...
Once you run this.. it looks like this:
And it looks like this:
Credit goes to Gerhard Pretorius for this useful post.
Tuesday, February 16, 2010
Microsoft SQL Server 2005
How can I change my default database in MS SQL 2005
Log in to SQL Server 2005 and click the New Query button. After that run the system stored procedure sp_defaultdb command as follows:
exec sp_defaultdb @loginame='login', @defdb='master'
To achieve this in Microsoft SQL Server Management Studio you need to edit your login by expanding the Security -> Logins node and then right clicking on your login name and selecting Properties. Once the properties page displays there should be a Default database dropdownlist under the General page as seen below:
Log in to SQL Server 2005 and click the New Query button. After that run the system stored procedure sp_defaultdb command as follows:
exec sp_defaultdb @loginame='login', @defdb='master'
To achieve this in Microsoft SQL Server Management Studio you need to edit your login by expanding the Security -> Logins node and then right clicking on your login name and selecting Properties. Once the properties page displays there should be a Default database dropdownlist under the General page as seen below:
Wednesday, February 3, 2010
Software Downloads
| Download Center | ||
|---|---|---|
| CodePlex | » | http://www.codeplex.com/ (Microsoft) |
| SourceForge | » | http://sourceforge.net/ |
Install
Backup and Deployment
Acronis => http://www.acronis.com/download/
CMS
Joomla => http://www.joomla.org/download.html
Wordpress => http://wordpress.org/
Databasing
MySQL => http://dev.mysql.com/downloads/
Navicat => http://navicat.com/
PostgreSQL => http://www.postgresql.org/
Sqlite => http://www.sqlite.org/
Disassembler
Reflector => http://www.red-gate.com/products/dotnet-development/reflector/
Extensions
Firebug => http://getfirebug.com/downloads (Firefox)
Framework
CodeIgniter => http://codeigniter.com/downloads/
JQuery => http://jquery.com/
JQuery UI => http://jqueryui.com/
PHP => http://php.net/downloads.php
YUI Library => ttp://developer.yahoo.com/yui/
IDE
NetBeans => http://netbeans.org/downloads/
Eclipse => http://www.eclipse.org/
IM
GTalk => http://www.google.com/talk/
MSN => http://explore.live.com/windows-live-messenger?os=other
Skype => http://www.skype.com/intl/en-us/get-skype/on-your-computer/windows/
ISO Utility
PowerISO => http://www.poweriso.com/download.htm
MagicISO => ttp://www.magiciso.com/tutorials/miso-magicdisc-history.htm
Issue Tracker
BugTracker.NET => http://ifdefined.com/bugtrackernet.html
Bugzilla => http://www.bugzilla.org/
Multimedia Player
VideoLAN => http://www.videolan.org/vlc/download-windows.html
XBMX => http://xbmc.org/download/
Office
Open Office => http://download.openoffice.org/
Photo Editors
FastStone Photo Resizer => http://www.faststone.org/FSResizerDownload.htm
GIMP => http://www.gimp.org/downloads/
Paint.NET => ttp://www.getpaint.net/download.html
Pixlr => http://pixlr.com/
Sumo Paint => http://www.sumopaint.com/home/
Remote Desktop Utility
Team Viewer => http://www.teamviewer.com/en/download/index.aspx
Social Networks
Facebook => http://www.facebook.com/
LinkedIn => http://www.linkedin.com/
Twitter => http://twitter.com/
Source Control
Git => http://git-scm.com/
SVN => http://subversion.apache.org/packages.html
Text Editors
E-TextEditor => http://www.e-texteditor.com/
Notepad++ => http://notepad-plus-plus.org/download
TextPad => http://www.textpad.com/download/
Web Browsers
Chrome => http://www.google.com/chrome/intl/en/landing_chrome.html?hl=en
Firefox =>
RockMelt => http://www.rockmelt.com/
Wiki
Screw Turn Wiki => http://www.screwturn.eu/
Zip Utilities
7Zip => http://www.7-zip.org/download.html
Online
Database Management
PhpMyAdmin => http://www.phpmyadmin.net/home_page/downloads.php
IDE
phpanywhere => http://phpanywhere.net/
Office
Google docs =>
Issue Tracker
Zoho => http://www.zoho.com/
Training
GCFLearnFree.org => http://www.gcflearnfree.org/
HTML5Rocks => ttp://www.html5rocks.com/
W3Schools => http://www.w3schools.com/
Still to sort
2 Advanced => http://www.2advanced.com/
Advanced System Care => http://www.iobit.com/advancedsystemcareper.html
Belarc Advisor => http://www.belarc.com/free_download.html
BurnAware => http://www.burnaware.com/
Cooliris => http://www.cooliris.com/
CutePDF => http://www.cutepdf.com/products/cutepdf/writer.asp
doPDF => http://www.dopdf.com/
DropBox => http://www.dropbox.com/install
Filezilla => http://filezilla-project.org/download.php
Foxit Reader => http://www.foxitsoftware.com/Secure_PDF_Reader/
Freshmeat => http://freshmeat.net/
Github => https://github.com/
Google Latitude => https://www.google.com/latitude/
Gmail => Gmail
Greenshot => http://getgreenshot.org/
IrfanView => http://www.irfanview.com/main_download_engl.htm
LastPass => https://lastpass.com/misc_download.php
Linq Pad => http://www.linqpad.net/
PathCopy => http://download.cnet.com/Path-Copy/3000-2072_4-10036463.html
PowerGUI => http://www.powergui.org/downloads.jspa
Secunia PSI => http://secunia.com/
Sendback
SnagIt => http://www.techsmith.com/download/snagit/default.asp
Spybot
StumbleUpon.com => http://www.stumbleupon.com/
VNC => http://vnc.en.softonic.com/
WinAmp => http://www.winamp.com/media-player/en
Xmind => http://www.xmind.net/downloads/
Yammer => https://www.yammer.com/company/desktop
Microsoft Visual Studio 2008
How do I change the default browser used in Visual Studio 2008
• Right click a page (.aspx, or on a folder)
• Select Browse With...
• Choose your browser
• Click set as Default
ASP.NET MVC
• Right click on Default.aspx
• Select Browse With...
• Choose your browser
• Click set as Default
How do I reload the cache of a website when pressing the start button (F5) in Visual Studio 2008
To reload the cache of the browser in Visual Studio 2008 when you've clicked the start button do the following:
• Once the browser has loaded up press and hold down the CTRL + F5 key.
How do I use a stored procedure with the linq data source
To use a stored procedure with the linq data source set the linq data sources ContextTypeName property to the DataContext class and create an OnSelecting method for the linq data source returning the stored procedure in the OnSelecting method. Below is an example to help explain the steps I've taken. In your .ascx, .aspx, etc file the linq data source should look something like below:
And your code behind will look something like the following:
How do I maintain the pages current position when inserting or updating a row in a GridView
To maintain the pages current position when inserting or updating a row in a GridView set your pages maintainScrollPositionOnPostBack attribute in the web.config to true as shown below:
• Right click a page (.aspx, or on a folder)
• Select Browse With...
• Choose your browser
• Click set as Default
ASP.NET MVC
• Right click on Default.aspx
• Select Browse With...
• Choose your browser
• Click set as Default
How do I reload the cache of a website when pressing the start button (F5) in Visual Studio 2008
To reload the cache of the browser in Visual Studio 2008 when you've clicked the start button do the following:
• Once the browser has loaded up press and hold down the CTRL + F5 key.
How do I use a stored procedure with the linq data source
To use a stored procedure with the linq data source set the linq data sources ContextTypeName property to the DataContext class and create an OnSelecting method for the linq data source returning the stored procedure in the OnSelecting method. Below is an example to help explain the steps I've taken. In your .ascx, .aspx, etc file the linq data source should look something like below:
And your code behind will look something like the following:
How do I maintain the pages current position when inserting or updating a row in a GridView
To maintain the pages current position when inserting or updating a row in a GridView set your pages maintainScrollPositionOnPostBack attribute in the web.config to true as shown below:
Subscribe to:
Posts (Atom)