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

Advertisements

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.

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