TODO:
You have table A, and Table B. Table A has a foreign key to table B, and table B has a foreign key to table A. You need to delete data from table A, but cannot because of the foreign key on Table B.
SOLUTION:
ALTER TABLE employee NOCHECK CONSTRAINT ALL
delete employee where id=100
ALTER TABLE employee WITH CHECK CHECK CONSTRAINT ALL
NOTES:
This will allow you to delete data when there arecircular foreign keys.
TODO:
Have you ever wanted to get the current user that is logged into SharePoint?
SOLUTION:
//set textfield to the user
txtModificationBy.Text = this.Web.CurrentUser.LoginName;
NOTES:
There are no notes on this topic.
TODO:
Have you ever wanted to print output messages in a stored procedure?
SOLUTION:
PRINT 'some string'
PRINT 'some string' + @SomeVariable
NOTES:
Note, if you are concatenating a numeric variable you will need to cast it to Varchar
TODO:
Have you ever wanted to enable the Disk Cleanup tool in Windows Server 2012?
SOLUTIONS:
To enable this tool, you have to install the Desktop Experience Feature, which is located in Control Panel -> Programs and Features -> Turn Windows Features On and Off ->Add Roles and Features -> Features.
NOTES:
There are no notes on this topic.
TODO:
Have you ever wanted to boot to recovery or safe mode?
SOLUTION:
Target Disk Mode
Option + T
Command Line Mode
Command + S
type fsck -cy
Recovery Mode or Selectable Boot Mode
Command + R or Option
Safe Mode
Hold Shift after startup tone on boot
Release when you see the Apple in the center of the screen
NOTES:
There are no notes on this topic
TODO:
Have you ever unplugged your headphones, and the internal speaker does not work, and it is simply greyed out? You will also see a red light coming out of the headphone jack.
SOLUTION:
Use a toothpick and wiggle it in the headphone jack hole. You can also insert and remove the headphones a few times and the internal speaker should kick on.
NOTES:
Sees to be a sensor gets stuck that turns on the Optical Input inside the headphone jack.
TODO:
Have you ever wanted to drop a column to an existing SQL Server Table using T-SQL?
SOLUTION:
ALTER TABLE Customer DROP COLUMN FavoriteColor
NOTES:
There are no notes on this topic
TODO:
Have you ever wanted to add a column to an existing SQL Server Table using T-SQL?
SOLUTION:
ALTER TABLE Customer ADD FavoriteColor VARCHAR(20)
NOTES:
There are no notes on this topic
TODO:
Have you ever wanted to insert the contents of a DataTable efficiently using SqlClient.BulkCopy?
SOLUTION:
public static void FillMonteCarloSimulationResults(DataTable InDataTable)
{
using (SqlBulkCopy bulkCopy = new SqlBulkCopy("myconnectionstring")
{
//***NOW Do column mappings. This maps columns from DataTable (left) to DB Table (right)
bulkCopy.DestinationTableName = "Results";
bulkCopy.ColumnMappings.Add("EmployeeId", "EmployeeId");
bulkCopy.ColumnMappings.Add("Name", "Name");
bulkCopy.WriteToServer(InDataTable);
}
}
NOTES:
This example will take the DataTable, map the columns, then preform BulkCopy
TODO:
You add a HTTPHandler to your SharePoint project, and you get the following error : "Parser Error Message: Could not load file or assembly '$SharePoint.Project.AssemblyFullName$' or one of its dependencies. The system cannot find the file specified."
SOLUTION:
The fix is simple, do the following:
1. Open your project file in NotePad
2. Find the PropertyGroup nodes.
3. Add a new PropertyGroup node.
<PropertyGroup>
<TokenReplacementFileExtensions>ashx;</TokenReplacementFileExtensions>
</PropertyGroup>
4. Re-Open your project file
NOTES:
There are no notes on this topic.