Drop Function If Exists

Posted on By David Kittell 
IF OBJECT_ID(N'dbo.RegexReplace') IS NOT NULL
    DROP FUNCTION dbo.RegexReplace
GO

Source: https://www.simple-talk.com/sql/t-sql-programming/tsql-regular-expression-workbench/

Originally Posted on August 6, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code MSSQL

Related Posts

Bytes To MegaBytes

Posted on

Function BytesToMegabytes(ByVal Bytes As String) As String Dim SetBytes As String SetBytes = "" If Bytes >= 1073741824 Then SetBytes = Format(Bytes / 1024 / 1024 / 1024, "#0.00") _ & " GB" ElseIf Bytes >= 1048576 Then SetBytes = Format(Bytes / 1024 / 1024, "#0.00") & " MB" ElseIf…

Read More

Count characters in a textbox using Javascript

Posted on

<script type="text/javascript"> function countChars(countfrom,displayto) { var len = document.getElementById(countfrom).value.length; document.getElementById(displayto).innerHTML = len; } </script> <textarea id="data" cols="40" rows="5" onkeyup="countChars(‘data’,’charcount’);" onkeydown="countChars(‘data’,’charcount’);" onmouseout="countChars(‘data’,’charcount’);"></textarea><br> <span id="charcount">0</span> characters entered. Originally Posted on July 15, 2013Last Updated on October 26, 2015 All information on this site is shared with the intention to help. Before any…

Read More