SQL Server | Remove Special Characters

I needed to remove all the special characters from a field in a particular table in SQL Server to be used for searching purposes. After searching (binging :P)… I found the next SQL Server Function which did the trick.

This Function Removes any special character from the string value passed. All characters except 0-9, a-z and A-Z are all removed, whilst the remaining characters are returned back.

ALTER FUNCTION dbo.RemoveSpecialCharacters
(
@s VARCHAR(256)
)
RETURNS VARCHAR(256) WITH SCHEMABINDING

BEGIN
IF (@s is null)
RETURN null Continue reading

CMS | Sitefinity Not Working on Windows 7 64-Bit

To solve this problem, you need to access IIS 7 Manager and make sure that the:

  • Application Pool is switched from Default to Classic
  • Logon User in Classic Application Pool is LocalSystem
  • Enable for 32-bit applications Continue reading

ProjectNINE | Malta’s New Web Design Concept

Project NINE | Website Design | Malta | Web Design

Project NINE is a new project aimed to small to medium businesses who want to get a great website design for a small price. This concept is going to be launched in November 9th @ 9:00 am.

More information will be uncovered soon… Stay updated by clicking Like on the Facebook button on www.nine.com.mt.

Or click here to go to our Project NINE’s facebook page.

Windows Phone 7 | The Launch

In less than an hour, the new Windows Phone 7 OS will be unveiled by Microsoft. The launch is going to be held in NYC where they will announce the details surrounding Windows Phone 7 launch dates and devices. Engadget is going to be live there and you can read what’s happening from this link or else watch the live presentation from Microsoft here.

Substring vs Substr | Javascript

The substring() method extracts the characters from a string, between two specified indices, and returns the new sub string. This method extracts the characters in a string between “from” and “to”, not including “to” itself. Continue reading

Error 29506 | SQL Server 2005 Management Studio Express

When i binged (yes I’m using bing :P), i found the following fix:

  • Search for Command Prompt in the Start Window (don’t press enter)
  • Right click on the shortcut found and select ‘Run as Administrator’
  • In the command prompt change the current directory to the folder where the SSMSEE installer is stored
  • Enter the following command .SQLServer2005_SSMSEE_x64.msi if you are running Windows 7/Vista 64 bit
  • Enter the following command .SQLServer2005_SSMSEE.msi if you are running Windows 7/Vista 32 bit
  • Press enter to start the installation

Happy Sql Server Managementing 🙂

Resources: here