SQL Cast from Varchar to Numeric

Tuesday, 20 October 2009 05:14

SQL Cast from Varchar to Numeric

If you are working a lot with numbers in SQL Server or other database, sometimes it’s necessary to cast a text to numeric or vachar to int or varchar to numeric datatype; to be successful, the precision of the destination variable must match the text for all scenarios.

Read more: SQL Cast from Varchar to Numeric

Customizing a Windows Theme

Tuesday, 20 October 2009 02:09

Customizing a Windows Theme

Ever want to create a new theme for your desktop? Microsoft offers great instructions to accomplish this. All you need is:

  1. An active imagination
  2. A photo you have taken, that’s rather descent
  3. Colors that match your photo and style
  4. Fonts that are a pleasure to read and nothing way too funky or this turns people off

http://windows.microsoft.com/en-us/windows7/customize-a-theme

If you need some photos, please visit our site at http://folio.snapjag.com; if you see something you like, email me and get a price for the download most are $5 for a 1024×768 desktop download.


Gallery

Brian Regan
Brian Regan is a tremendous comedian. He has toured the nation and been extremely successful with is humor, wit, and especially good taste in comedy. There aren’t many comedians that uphold a great repetoir of good jokes, but if you haven’t seen Brian, he sure aims to please. More
Linkin Park
West Valley City, Utah – The E Center http://www.myspace.com/linkinpark When I arrived with my friend to the E Center we found that the parking, even two blocks away was packed. The restaurants around the vicinity, I’m sure weren’t packed with patrons, but the cars were those of the concert goers. With a sell out crowd of 11,000 people, the representation of the group was phenomenal, an understatement. More
C# Console Application Versions
Well, something stumped me. But figured it out … As part of my C# console application, I wanted to print out the version (Major.Minor.Revision) as part of the help output so I could know the release details. And without the Application object, I just wanted the simple information from the build assembly. More
ORA-00911 invalid character
I am using .NET 2005 and the Oracle 10g 10.2 Oracle .NET data framework and I received this error while trying to run a simple statement that is used to find out how many dedicated processes are being used in my Oracle database (”select count(server) as Value, Server from v$session group by server”). Something similar to ActiveConnections in the SQL .NET SMO environment. This happened with both Oracle .Net Data Framework Assembly and the Microsoft SQL OLEDB Assembly. More

Resources


Visit our photo store to see and purchase great photos. We promise, you'll like them.

Devils Fork

Our Recommended! (1 user, 1 year protection) BitDefender Internet Security 2009 keeps your Internet-connected family safe, without slowing down their PCs. It locks out viruses, hackers & spam, while providing parental control and firewall protection. Buy BitDefender Internet Security 2009 Now.

Need protection for 2 years or 2 users?

Corporate

We are proudly hosted at MediaTemple. One of the great server infrastructures.

Media Temple

If you are a company needing Elite Concierge Hosting, visit our Redbosque.com Digital Communities(TM) website for hosting solutions. Understand though that it's only for select companies that qualify.