Skip to content

GoldenNugets

Just trying to help someone out there :)

Category Archives: SQL Server

Strip text and extract numeric value from string using TSQL

Today I had an issue that someone changed format of a string pattern our SQL was expecting. I came across a function written by George Mastros that addressed my SQL needs. Long story short we have a string with text then a number and some more text. What we need is to extract the numeric value from this […]

Posted byadminSeptember 18, 2013June 10, 2014Posted inSQL Server

SQL server date format issue – kind of

So you find yourself that your software was written for say UK English but the system is installed from US English. This can happen in numerous cloud migration projects. Well the issue can be overcome in several ways but one way that I liked in particular is to alter the user’s default language. This assumes […]

Posted byadminMarch 15, 2013June 10, 2014Posted inCloud, programming, SQL Server

Recent Posts

  • Long time no hear…
  • Centos 6/7 network issues after moving VM to another Hyper-V server
  • Postfix regenerate DB files
  • Reset replication address in MySQL slave
  • Condensed Linux disk mounting on Azure

Archives

  • March 2019
  • August 2015
  • July 2014
  • June 2014
  • February 2014
  • November 2013
  • September 2013
  • August 2013
  • June 2013
  • April 2013
  • March 2013

Categories

  • C#
  • CentOS
  • Cloud
  • Exchange 2010
  • IIS
  • Linux
  • MySQL
  • programming
  • SQL Server
  • System Administration
  • Ubuntu
  • Uncategorized
  • Windows

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
GoldenNugets, Proudly powered by WordPress.