This quick reference introduces you a more flexible way to delete data from multiple tables by using INNER JOIN or LEFT JOIN clause in the DELETE statement. MySQL DELETE JOIN with INNER JOIN Syntax MySQL DELETE JOIN with INNER JOIN Example MySQL DELETE JOIN with LEFT JOIN Example
These commands allows to quickly access features and applications to customize operative system environment. These run commands are available for almost all settings available in Windows control panel. Function in Windows Common Command Open Documents Folder documents Open Videos folder videos Open Downloads Folder downloads Open Favorites Folder favorites Open Recent Folder recent Open Recent Folder logoff Open Pictures Folder pictures Windows Sideshow control.exe /name Microsoft.WindowsSideshow Windows CardSpace control.exe /name Microsoft.cardspace Windows Anytime Upgrade WindowsAnytimeUpgradeui Taskbar and Start Menu control.exe…
These commands allows to quickly access features and applications to customize operative system environment. Here is a quick list of them. Admin Program Command AD Domains and Trusts domain.msc Active Directory Management admgmt.msc AD Sites and Services dssite.msc AD Users and Computers dsa.msc ADSI Edit adsiedit.msc Authorization manager azman.msc Certification Authority Management certsrv.msc Certificate Templates certtmpl.msc Cluster Administrator cluadmin.exe Computer Management compmgmt.msc Component Services comexp.msc Configure Your Server cys.exe Device Manager devmgmt.msc DHCP Management dhcpmgmt.msc Disk Defragmenter dfrg.msc Disk…
This article explains how to disable the Internet Explorer Enhanced Security Configuration (IE ESC) in Windows Server 2012. One of the downsides of dealing with a new version of Windows Server is figuring out where things have moved in the new release. In Windows Server 2008 R2, disabling IE ESC was fairly straightforward in the Server Manager. Disabling it in the latest Microsoft Server OS is still performed in the Server Manager. However, the redesign of the Server Manager…
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. Here are some samples:
Following script are very useful to know all the constraint in the database. I use this many times to check the foreign key and primary key constraint in database. This is simple but useful script from my personal archive.
