get a substring in SQL SERVER using space as separator source: http://www.dreamincode.net/forums/topic/239440-how-can-i-get-a-substring-in-sql-server-using-space-as-separator/ CHARINDEX (Transact-SQL) http://msdn.microsoft.com/pt-pt/library/ms186323.aspx SUBSTRING (Transact-SQL)http://msdn.microsoft.com/en-us/library/ms187748.aspx
Infographic: HTML5 and Why Developers Need It
HTML5 Infographic by Ignite UI Infragistics Jquery Controls source: http://www.infragistics.com/community/blogs/marketing/archive/2012/11/27/infographic-html5-and-why-developers-need-it.aspx
mysql ‘Proper case’ formating a column?
How to do something like: Proper(“GALHANO.COM”) = “Galhano.com” there’s no builtin function to do this but we combine CONCAT and SUBSTRING:
Enterprise Library
The Microsoft Enterprise Library is a collection of reusable software components (application blocks) designed to assist software developers with common enterprise development cross-cutting concerns (such as logging, validation, data access, exception handling, and many others). Application blocks are a type of guidance; they are provided as source code, test cases, and documentation that can be used “as is,” extended, or modified by developers to use on complex, enterprise-level line-of-business development projects.
Yahoo Condition Code
Yahoo Condition Code Condition codes are used in to describe the current conditions. If you want to personalize conditions image icon, you must provide this set of icons: Code Description 0 tornado 1 tropical storm 2 hurricane 3 severe thunderstorms 4 thunderstorms 5 mixed rain and snow 6 mixed rain and sleet 7 mixed snow and sleet 8 freezing drizzle 9 drizzle 10 freezing rain 11 showers 12 showers 13 snow flurries 14 light snow showers 15 blowing snow 16 snow 17 hail 18 sleet 19 dust 20 foggy 21 haze 22 smoky 23 blustery 24 windy 25 cold 26 …
Outlook.com
With the arrival and availability of its latest e-mail service, the Outlook.com, Microsoft takes a giant step forward in renewing the service Hotmail disponibilizava, and seeks to bring back all users over the years were opting for other services that were appearing and showed themselves better.This email service based on the Internet has all the features you would expect from a similar platform, but also brought some of the features that were already in Hotmail, albeit reinvented and adapted to this new platform. One of the most interesting that we have at Outlook.com is the ability to create email addresses …
Computer Hardware Chart
Yahoo! Query Language
What is YQL? The Yahoo! Query Language is an expressive SQL-like language that lets you query, filter, and join data across Web services. With YQL, apps run faster with fewer lines of code and a smaller network footprint. Yahoo! and other websites across the Internet make much of their structured data available to developers, primarily through Web services. To access and query these services, developers traditionally endure the pain of locating the right URLs and documentation to access and query each Web service. With YQL, developers can access and shape data across the Internet through one simple language, eliminating the …
Gerenating a GUID using Delphi 7
GUID – Globally Unique IDentifier In Delphi, GUID values are represented with the TGuid record defined in the System unit. A Guid value is a 128-bit integer (16 bytes) that can be used in database applications when a unique identifier is required. When developing database applications, the TGuidField is used to represents a guid field in a dataset.
Consuming ASP.NET 2.0 Web Services in Delphi for Win32
A couple of years ago I wrote an article Consuming C# Web Services with Delphi 7 Professional, and while the information in the article is still correct, it’s no longer complete, because ASP.NET 2.0 changed the rules a little bit. Even if you follow the examples exactly on creating the web service in C# and in creating the consuming application in Delphi for Win32, no matter what you try to echo, the result will always come back as 0 for numbers or as an empty string for strings. This is due to the fact that the C# web service is …