Monday, October 17, 2016

Cupid's Reason

Q: Why does Cupid shoot us with his arrows?
A: So we can love with our HOLE heart.

Monday, October 3, 2016

OPC Hits: Yeng Constantino, "Paasa (T.A.N.G.A.)"

Yeng Constantino is continuing on her tradition of topping the OPC Hits chart. Following her #1 songs "Ferris Wheel," "Dance Without the Music," "What's Up Ahead" featuring husband Yan Asuncion, and "Shining Like the Sun (Baby Are You Ready)" is another track which people could easily relate to, especially in this age of social media. Here's "Paasa (T.A.N.G.A.)," now on its fourth week at #1.

OPC Hits
October 2-8, 2016

112@13Kenny ChesneySetting the World on Fire [feat. Pink]
2222SiaThe Greatest [feat. Kendrick Lamar]
331@14Cash CashMillionaire [with Digital Farm Animals feat. Nelly]
4444BastilleGood Grief
5552Yeng ConstantinoPaasa (T.A.N.G.A.)
6962JoJoMad Love
7-71Kings of LeonWaste a Moment
8772Olly MursYou Don't Know Love
9-23Shawn MendesMercy
10-101Mike PerryThe Ocean [with Shy Martin]
112@13Britt NicoleThrough Your Eyes
2225Tauren WellsLove Is Action
3-31Danny GokeyRise
431@13Building 429Be with Us Now (Emmanuel)
5423Hawk NelsonLive Like You're Loved
654@18Casting CrownsOne Step Away
761@16Jason GrayCelebrate
8728Every Nation MusicAuthor of My Life [feat. Bryson Breakey]
9-91Lauren DaigleCome Alive (Dry Bones)
10992Colin BakerHeaven Open
114@14Yeng ConstantinoPaasa (T.A.N.G.A.)
2222Mark CarpioHiling
332@16Hazel FaithKinikilig
4426Leanne and NaaraAgain
5536Rico BlancoWag Mong Aminin

Saturday, October 1, 2016

SQL Error on Unnecessary varchar to int Conversion


Consider the following table:

CREATE TABLE [dbo].[AuditTrail](
[AuditTrailID] [int] IDENTITY(1,1) NOT NULL,
[UserID] [int] NOT NULL,
[FieldName] [varchar](50) NULL,
[OldValue] [varchar](max) NULL,
[NewValue] [varchar](max) NULL

And consider the following script:

DECLARE @OldRoleID int
DECLARE @NewRoleID int

DECLARE @OldUsername varchar(25)
DECLARE @NewUsername varchar(25)

SET @OldRoleID = 1
SET @NewRoleID = 2

SET @OldUsername = 'Juan'
SET @NewUsername = 'John'

(1, 'RoleID', @OldRoleID, @NewRoleID),
(1, 'Username', @OldUsername, @NewUsername);

Sunday, September 25, 2016

Britt Nicole, "Through Your Eyes" [OPC Hits 2016.9.25]

Britt Nicole has just added another hit on her growing catalog here on the OPC Hits chart. After topping the charts with "Gold" in 2012, and "You're Not Alone" with Owl City in 2014, she scores another #1 hit this year with "Through Your Eyes," the lead single off her upcoming self-titled fourth studio album, due on October 7. She's surely come a long way from 2007 when I first heard her track "You." Here's our current leader on the Praise Parade chart, up two after debuting at #3 last week:

OPC Hits
September 25-October 1, 2016

161@12Kenny ChesneySetting the World on Fire [feat. Pink]
2-21SiaThe Greatest [feat. Kendrick Lamar]
311@13Cash CashMillionaire [with Digital Farm Animals feat. Nelly]
4-43BastilleGood Grief
5-51Yeng ConstantinoPaasa (T.A.N.G.A.)
631@13Christina GrimmieWithout Him
7-71Olly MursYou Don't Know Love
8-81Mark CarpioHiling
9-91JoJoMad Love
10-101Zara LarssonAin't My Fault
131@12Britt NicoleThrough Your Eyes
2724Tauren WellsLove Is Action
311@12Building 429Be with Us Now (Emmanuel)
4222Hawk NelsonLive Like You're Loved
554@17Casting CrownsOne Step Away
641@15Jason GrayCelebrate
7627Every Nation MusicAuthor of My Life [feat. Bryson Breakey]
8845CitylovemusicNearer to You
9-91Colin BakerHeaven Open
113@13Yeng ConstantinoPaasa (T.A.N.G.A.)
2-21Mark CarpioHiling
322@15Hazel FaithKinikilig
4325Leanne and NaaraAgain
5435Rico BlancoWag Mong Aminin