In this series at Part 1 Removing unwanted characters
, I posted a method that used a function. In part 2
I posted a method that used Dynamic SQL.
Here is another improved method that uses Dynamic SQL
--Create test data
create table #data (data varchar(100))
select 'tes^@&t %stri)-n!g' data union all
select '))aaer***********)' union all
select '&^&&hsdf()' union all
select 'jj&wk' union all
select ')hw*pa' union all
select 'No&@#$53*24,Mai()$n R--!oad'
--Create table that has all set of characters to be removed
create table clean_chars (char_id int identity(1,1),chars char(1))
insert into clean_chars (chars)
select '^' as repl union all
select ')' union all
select '&' union all
select '*' union all
select '%' union all
select '@' union all
select '-' union all
select ',' union all
select '#' union all
select '$' union all
select '#' union all
declare @sql varchar(max), @select varchar(max)
select @select=@select+'replace(', @sql=@sql+','''+chars+''','''')' from clean_chars
select @select='select data,'+@select+'data'+@sql+' as cleaned_data from #data'
The result is
tes^@&t %stri)-n!g ...(Read whole news on source site)
At the end of what's been a kind of tough week, with a spring cold making its way through my entire family (one of the perils of having young kids at home), I got a nifty package in the mail. Inside was an anti-static foil bag containing the parts for a nifty addition to my Gadgeteer hardware collection, the new MIDI Module
created by my friend and fellow Microsoftie Pete Brown
. I should have thought to snap a photo of the kit before assembling it, but I was sufficiently excited I could hardly wait to heat
up the soldering iron. Here's what the finished module looks like:
So, OK, you might ask. Looks neat, and all, but what does it DO? Well, for the uninitiated, MIDI stands for Musical Instrument Digital Interface
, and the short definition is that it's a serial protocol specification that lets musical instruments "talk" to one another. MIDI allows devices to communicate musical information (which note to play, how loudly to play it, etc.) digitally in a highly efficient format. Instead of creating a waveform and pushing it through limited bandwidth pipes, MIDI allows a controller device to...(Read whole news on source site)
Here are the events listed in Community Megaphone
for the next week (or so) for the Mid-Atlantic area, as well as webcasts of interest…this list includes events imported from the UGSS event calendar
, and user group events entered in Community Megaphone are also automatically synced to the UGSS event calendar: MD CMAP Main Meeting - Windows 8 - The Developer's View - Joel Cochran
Tuesday, April 10, 2012 6:30 PM, Columbia, MD
Topic: Windows 8 - The Developer's View
In this session we'll take a quick tour of Windows 8 and then turn our attention to developer issues
and tools. Topics of discussion will include Desktop vs. Metro, .NET vs. WinRT, touch vs. mouse and keyboard, XAML vs. HTML, and more. Whatever your preferences, this presentation should help prepare for the future of Windows.
Presenter: Joel Cochran
Joel Cochran is an Expression Blend MVP, an INETA Community Champion, and a Microsoft Certified Technology Specialist (MCTS) in Windows Forms and WPF. He is the founder of BlendSIG, a virtual Special Interest Group focused on Expression Blend and author of "Expression Blend in Action" by Manning Publications. He is also the author of "The Practical MVVM Manifesto" (http://practicalmvvm.com). He has been developing...(Read whole news on source site)
Beginning with version 2.0, ASP.NET MVC has shipped with a set of templates for both displaying and editing data. These templates are buried within the System.Web.Mvc assembly. While you can override them outright, you cannot easily extend them since they’re locked down. The new MvcDisplayTemplates NuGet
package fixes this problems. If you’re not already familiar with ASP.NET MVC’s templating system, I strongly suggest you go check out Brad Wilson’s posts on the subject
. Though his posts are for MVC 2.0, they’re still just as relevant today as they were in 2009.
The MvcDisplayTemplates package will add a DisplayTemplates folder to your project containing all of the standard templates:
They’ll behave very similarly to the built-in templates from the System.Web.Mvc assembly with one minor difference. All the templates leverage a layout file that decorates the displayed value with an identifier generated from the model: @using Microsoft.Web.Mvc
This simple, benign change makes it far easier to discern where values from a view model are located within the output HTML. Without that, frameworks such as SpecsFor.Mvc
couldn’t easily locate values within the page. If...(Read whole news on source site)
Around eight years ago I wrote a blog post about Repetitive Strain Injury
entitled The Real Pain of Software Development [part 1]
. I soon learned the lesson that it’s a bad idea to have “Part 1” in any blog post unless you’ve already written part 2. But here I am, eight years later, finally getting around to part 2. But better late than never!
The original reason that led me to write about this topic was a period of debilitating pain I went through when coding. Too many long hours at
the keyboard took their toll on me so that even placing my fingers on the keyboard would cause me pain. I experienced numbness in my fingers, pain in my wrists, back and shoulders, and lots of headaches. In short, I was a mess. Road to Recovery Fortunately, my employer at the time was supportive of me filing a Worker’s Compensation claim. I know for some, that has a negative connotation, but keep in mind it’s insurance that you pay in to specifically for cases of injuries. So it makes sense to use it if you’re legitimately injured on...(Read whole news on source site)
The F# language was born as a combination of the pragmatic and real-world .NET
platform and functional programming, which had a long tradition in academia.
Many useful ideas or libraries in F# (like asynchronous workflows and
first-class events) are inspored by research in functional programming
(namely, the work on monads, continuations and functional reactive programming).
Exchanging the ideas between the research community and the real-world is one
of the areas where F# excels. Indeed, the first applicatiosn of F# inside Microsoft
(in the Machine Learning group at Cambridge) were all about this - combining
research in machine learning with a language that can be easily
used in practice.
However, F# and the F# users also made numerous contributions to the programming
langauge research community. Influential ideas that come from F# include
active patterns and the F# style of meta-programming for translating F# to
from the F# community, so I'd like to invite you to talk about your ideas
at two upcoming academic events!
What, why, when, where and how? Continue reading!
...(Read whole news on source site)
C# 4.0 language includes a new feature called Tuple. Tuple provides us a way of grouping elements of different data type. That enables us to use it a lots places at practical world like we can store a coordinates of graphs etc. In C# 4.0 we can create Tuple with Create method. This Create method offer 8 overload like following. So you can group maximum 8 data types with a Tuple. Followings are overloads of a data type. Create(T1)- Which represents a tuple of size 1 Create(T1,T2)- Which represents a tuple
of size 2 Create(T1,T2,T3) – Which represents a tuple of size 3 Create(T1,T2,T3,T4) – Which represents a tuple of size 4 Create(T1,T2,T3,T4,T5) – Which represents a tuple of size 5 Create(T1,T2,T3,T4,T5,T6) – Which represents a tuple of size 6 Create(T1,T2,T3,T4,T5,T6,T7) – Which represents a tuple of size 7 Create(T1,T2,T3,T4,T5,T6,T7,T8) – Which represents a tuple of size 8 Following are some example code for tuple. using System;
...(Read whole news on source site)
I recently got a bit depper into Bing Maps development, and I have been mesmerized by their richness and capabilities. With that said, I had an idea that Bing Maps are one of those products that are simply tailor made … Continue reading →
Quick tip here on using oData with NuGet. If you have visited the NuGet Gallery, you may have wondered were the RSS feed is. Try as you might, you won’t find it. There’s good reason for that given the fact … Continue reading →