| Page Item | Value |
| Title | SQL Server Help: Transact SQL Programming Articles |
| Description | SQL Server articles providing assistance in particular aspects of Transact SQL programming |
| Keywords | tutorials, examples, sql server, tsql, transact sql, sql, advise, help, nulls, ordering |
| Robots Meta Tag | |
| Page Content | HOME | ABOUT ME | BIOTECHNOLOGY | ARTICLES | TOOLS | GALLERY | CONTACT Search: Go DEVELOPER TOOLS ASP Doc Tool ASP.NET Doc Tool SQL Doc Tool Index Server Companion The Website Utility TECHNICAL ARTICLES ASP ASP.NET JavaScript Transact SQL PHOTO GALLERIES Canon EOS 300D Samples Red Arrows 2004 Living Coasts Web Page Backgrounds More Galleries... NEW STUFF SQL Color Coder Canon EOS 300D Samples The Website Utility Search Engine Optimisation Build an ASP Search Engine My Tropical Fishtank Savings Other New Stuff... POPULAR STUFF Regular Expressions ASP Documentation Tool Index Server ASP JavaScript Ad Rotator LINKS Business Website ASPAlliance Articles
Home Articles Transact SQL Programming Articles The following articles and tutorials provide assistance with the Transact SQL programming language used by Microsoft's SQL Server: Making Null Values Appear Last in SQL Server Result Sets . Generating Random Numbers in Transact-SQL . Generating Randomly Ordered SQL Server Result Sets . Generating Random Strings of Characters in Transact-SQL . Using SET ROWCOUNT to Limit the Number of Rows Returned . Using the Transact SQL Case Statement . Changing Case of Strings (Upper and Lower Case) . Trimming Strings in Transact-SQL . Determining String Length in Transact-SQL . Detecting Numbers in Transact-SQL Using the IsNumeric Function . Extracting Substrings From Strings in Transact-SQL . Selecting Left and Right SubStrings of Strings in Transact-SQL . String Comparisons in Transact-SQL Using the Like Function . Using the Transact SQL Coalesce Statement . Using @@Rowcount to Determine the Number of Rows Affected by a SQL Statement . Using the Transact SQL ASCII and Char Functions . Pattern matching using the Patindex and Charindex functions. Useful Links The SQL Documentation Tool builds technical documentation for Microsoft SQL Server databases. A free trial version is available for download. The ASP Documentation Tool can automatically document your ASP (VBScript and JScript) websites and SQL Server/Microsoft Access databases. An ASP.NET Documentation Tool is also available! Site Map All content is © 1995 - 2006 Brett Burridge |
| Image Alt Tags | Brettb.Com Microsoft Certified Professional |
| Internal Links | http://www.brettb.com/Default.asp (3 links in this page) [ Robot View of this URL ] http://www.brettb.com/ASPDocumentationTool.asp (2 links in this page) [ Robot View of this URL ] http://www.brettb.com/technicalwriting.asp (2 links in this page) [ Robot View of this URL ] http://www.brettb.com/DeveloperTools.asp (2 links in this page) [ Robot View of this URL ] http://www.brettb.com/TheWebsiteUtility.asp (2 links in this page) [ Robot View of this URL ] http://www.brettb.com/Gallery.asp [ Robot View of this URL ] http://www.brettb.com/SearchingIndexServerWithASP.asp [ Robot View of this URL ] http://www.brettb.com/SQL_Help_Reverse_Ordering_Nulls.asp [ Robot View of this URL ] http://www.brettb.com/SQL_Help_Left_Right.asp [ Robot View of this URL ] http://www.brettb.com/SQL_Help_Randomly_Ordering.asp [ Robot View of this URL ] http://www.brettb.com/JavaScriptArticles.asp [ Robot View of this URL ] http://www.brettb.com/SQL_Help_Random_Strings.asp [ Robot View of this URL ] http://www.brettb.com/Website_Search_Engine_Optimisation.asp [ Robot View of this URL ] http://www.brettb.com/SQL_Help_PatIndex_Function.asp [ Robot View of this URL ] http://www.brettb.com/SearchResults.asp [ Robot View of this URL ] http://www.brettb.com/js_banner_ad_rotator.asp [ Robot View of this URL ] http://www.brettb.com/SQL_Help_Coalesce_Statement.asp [ Robot View of this URL ] http://www.brettb.com/web.asp [ Robot View of this URL ] http://www.brettb.com/SQL_Help_Len_String_Length.asp [ Robot View of this URL ] http://www.brettb.com/SQL_Help_Random_Numbers.asp [ Robot View of this URL ] http://www.brettb.com/CanonEOS300D_Gallery1.asp [ Robot View of this URL ] http://www.brettb.com/SQL_Help_Rowcount_Rows_Affected.asp [ Robot View of this URL ] http://www.brettb.com/SQL_Help_Trimming_Strings.asp [ Robot View of this URL ] http://www.brettb.com/SQL_Help_Case_Statement.asp [ Robot View of this URL ] http://www.brettb.com/BuildingAnASPSearchEngine.asp [ Robot View of this URL ] http://www.brettb.com/backgrounds.asp [ Robot View of this URL ] http://www.brettb.com/VBScriptRegularExpressions.asp [ Robot View of this URL ] http://www.brettb.com/toc.asp [ Robot View of this URL ] http://www.brettb.com/SQL_Help_Rowcount_Limit_Rows.asp [ Robot View of this URL ] http://www.brettb.com/ASP.NETArticles.asp [ Robot View of this URL ] http://www.brettb.com/Investments_ISAs.asp [ Robot View of this URL ] http://www.brettb.com/SQL_Help_CharIndex_Function.asp [ Robot View of this URL ] http://www.brettb.com/SQL_Help_Change_Lower_Upper_Case.asp [ Robot View of this URL ] http://www.brettb.com/TransactSQLColorCoder.asp [ Robot View of this URL ] http://www.brettb.com/MyTropicalFishtank.asp [ Robot View of this URL ] http://www.brettb.com/CanonEOS300D_Gallery3.asp [ Robot View of this URL ] http://www.brettb.com/SQL_Help_IsNumeric_Function.asp [ Robot View of this URL ] http://www.brettb.com/ASPWatchArticles.asp [ Robot View of this URL ] http://www.brettb.com/Red_Arrows_2004.asp [ Robot View of this URL ] http://www.brettb.com/Living_Coasts_Photos.asp [ Robot View of this URL ] http://www.brettb.com/SQL_Help.asp [ Robot View of this URL ] http://www.brettb.com/contact.asp [ Robot View of this URL ] http://www.brettb.com/SQL_Help_Like_Function.asp [ Robot View of this URL ] http://www.brettb.com/SQL_Help_SubStrings.asp [ Robot View of this URL ] http://www.brettb.com/Biotechnology.asp [ Robot View of this URL ] http://www.brettb.com/SQL_Help_ASCII_Char_Functions.asp [ Robot View of this URL ] http://www.brettb.com/ASPNetDocumentationTool.asp [ Robot View of this URL ] http://www.brettb.com/gallery.asp [ Robot View of this URL ] http://www.brettb.com/what's_new.asp [ Robot View of this URL ] http://www.brettb.com/IndexServerCompanion.asp [ Robot View of this URL ] |
Report generated by The Website Utility 2.8