So, I’ve been doing a lot of SQL Scripting lately and I’ve come to a stop when I hit a problem I have never hit before. I had to update ColumnA of TblA with ColumnB of TblB. So my initial thought was to do an INNER JOIN UPDATE. So I started typing: UPDATE a
SET a.ColumnA = b.ColumnB
FROM TblA a
INNER JOIN TblB b
And then it hit me. How do I join them? They don’t have any type of relationship. Started thinking and talking to Edgar and decided to use ROW_NUMBER() to join both tables.
UPDATE a
SET a.ColumnA =...
The other day I was playing with WP7 Panorama’s Control and the default Title was HUGE! I wanted to change it, but wasn’t sure how to do so. After reading the docs I found the TitleTemplate property, which allows you to create the template used for the Title. Here’s how I use it: 1: <controls:Panorama.TitleTemplate>
2: <DataTemplate>
3: <TextBlock Text="{Binding Content, RelativeSource={RelativeSource TemplatedParent}}" FontSize="100" Margin="0,50,0,0"...
If you can’t attend the Microsoft Professional Developers Conference (PDC) 2010 in Redmond, WA you now have the ability to experience it locally via face to face interactive sessions. I will be speaking about Windows Phone 7. You can find more info here. See you there!