corviTech Solutions
  • Get In Touch
    • Blog
    • Contact Us
Select Page
SQL: Remove white space characters from all columns in SQL database

SQL: Remove white space characters from all columns in SQL database

by Johan Meyer | Jun 12, 2014 | Development, SQL Server

While working on a client project we noticed that all string columns has been set to varchar columns on the SQL database.  This was a small issue as all columns now contains empty spaces when not used and we wanted to remove white space characters from all columns in...
Exporting Microsoft SharePoint 2010 list to SQL server database

Exporting Microsoft SharePoint 2010 list to SQL server database

by Johan Meyer | Mar 7, 2013 | Development, SharePoint, SQL Server

Exporting Microsoft SharePoint 2010 list to SQL server database

Extract files from SharePoint Content Database using SQL

by Johan Meyer | Feb 14, 2013 | Development, SharePoint, SQL Server

If you ever had the problem where you need to extract files from a SharePoint Content Database or normal SQL Database stored as binary, this post will help you. The script I have included will export all the content from the SharePoint Content Database to the file...
Visual Studio Data Provider unexpected error fix

Visual Studio Data Provider unexpected error fix

by Johan Meyer | Mar 6, 2012 | .NET, Development, Visual Studio

After upgrading my Visual Studio 2008 to Visual Studio 2010 my server explorer decided to give me the following error. An unexpected error occurred in the .NET framework data provider for Microsoft SQL Server Compact. Please contact the provider vendor to resolve this...

Tags

.NET Appcelerator ASP.Net C# Custom Controls Data provider debug development dojo email feedburner feeds firebug firefox fixes javascript jquery K2 Blackpearl Microsoft PowerShell regex registry Regular Expression Reports Report Viewer SAP SharePoint SQL Script SQL Server System.Drawing Team Foundation Server 2010 tips tips&tricks Tips & Tricks Titanium tools tricks Virtual Box Visual Studio 2010 VMware Windows wordpress WP xpage xpages

Recent Posts

  • Enable K2 blackpearl checkbox validation
  • Appcelerator Cloud Service: Failed to authenticate to Node.ACS
  • SQL: Remove white space characters from all columns in SQL database
  • Appcelerator Tip: Enable your Project in the list of Projects when performing a Clean
  • Creating a custom control text box with validation

Archives

  • September 2016
  • June 2014
  • December 2013
  • March 2013
  • February 2013
  • March 2012

Categories

  • .NET
  • Appcelerator
  • Development
  • K2 Blackpearl
  • PHP
  • RegEx
  • Reporting
  • SharePoint
  • SQL Server
  • TFS
  • Tips & Tricks
  • Visual Studio
  • Windows
  • Wordpress
  • XPages
  • Facebook
  • Twitter
  • Google
  • RSS
Designed by CorviTech Solutions