http://www.blackwasp.co.uk/New articles, tips and tricks at the BlackWasp web site.en-us Sun 22 Nov 2009 00:00:00 GMT Sun 22 Nov 2009 00:00:00 GMT 1440http://www.blackwasp.co.uk/rss/RSSLogo.gif12060http://www.blackwasp.co.uk/ Copyright (c)2006-2009 BlackWasp http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/vrpDA_lFapE/SQLTrimFunctions.aspxThe forty-seventh part of the SQL Server Programming Fundamentals tutorial continues the investigation of Transact-SQL (T-SQL) string processing functions. This article describes two functions that remove leading and trailing white space from strings.http://www.blackwasp.co.uk/SQLTrimFunctions.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/kWhMn6BJJ3c/SQLStringCaseFunctions.aspxThe forty-sixth part of the SQL Server Programming Fundamentals tutorial continues the discussion of Transact-SQL (T-SQL) string processing functions. This article describes two functions that allow text to be converted to upper or lower case.http://www.blackwasp.co.uk/SQLStringCaseFunctions.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/0OGotAfnCkg/SQLStringIndexFunctions.aspxThe forty-fifth part of the SQL Server Programming Fundamentals tutorial continues the discussion of Transact-SQL (T-SQL) string processing functions. This instalment considers functions that read or modify character data at a specific index position.http://www.blackwasp.co.uk/SQLStringIndexFunctions.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/2LHdgouCGOc/SQLSubstringFunctions.aspxThe forty-fourth part of the SQL Server Programming Fundamentals tutorial begins a look at the string processing functions provided by Transact-SQL (T-SQL). This article describes three functions that allow you to extract substrings from character types.http://www.blackwasp.co.uk/SQLSubstringFunctions.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/WJaOBsBx1eQ/SQLRandom.aspxThe forty-third part of the SQL Server Programming Fundamentals tutorial completes the examination of Transact-SQL's (T-SQL) mathematical functions. This article describes the Rand function, which allows the generation of pseudo-random numbers.http://www.blackwasp.co.uk/SQLRandom.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/0nDZxonUBM0/blackwaspukYou can now follow BlackWasp on Twitter. Check out the linked profile page and keep up to date on changes to tutorials, articles and other projects. You can also link via the new Twitter icon in the footer of each page at http://www.blackwasp.co.uk/http://www.twitter.com/blackwaspuk http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/ddwGn2ab5xY/SQLLogFunctions.aspxThe forty-second part of the SQL Server Programming Fundamentals tutorial continues the examination of the mathematical Transact-SQL (T-SQL) functions. This article considers the logarithmic functions that are provided by Transact-SQL.http://www.blackwasp.co.uk/SQLLogFunctions.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/Y0F3FpT69qs/ApplicationSettings.aspxThere are various ways to hold application-wide and user-specific settings externally to a program. One is to set up application settings in a Visual Studio project. These permit strongly typed configuration that can be changed without recompiling.http://www.blackwasp.co.uk/ApplicationSettings.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/jJbPo61MYEU/SQLTrigFunctions.aspxThe forty-first part of the SQL Server Programming Fundamentals tutorial continues the examination of Transact-SQL (T-SQL) mathematical functions. This article considers the trigonometric functions that allow SQL Server to work with angular data.http://www.blackwasp.co.uk/SQLTrigFunctions.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/9wppZ2_CV-8/CharacterTesting.aspxWhen developing software that may be deployed in many countries, it is important to be able to determine the type of a character according to the rules of the local culture and language. The Char structure provides methods to simplify this process.http://www.blackwasp.co.uk/CharacterTesting.aspx