Tech Tips, Tricks & Trivia

From SQLXML.org 1) Generate a file with the text-editor like: <%begindetail%> <%insert_data_here%> <%enddetail%> Save it as c:\temp\template.tpl 2) Open Query Analyzer and type: sp_makewebtask @outputfile = 'c:\temp\myxmlfile.xml', @query = 'select * from sysobjects for xml auto', @templatefile = 'c:\temp\template.tpl' The result is a XML-File! More ^

Internationalization is often abbreviated as I18N (or i18n or I18n), by IBM and others, where the number 18 refers to the number of letters omitted. "Localization" is often abbreviated l10n in the same manner. Internationalization and localization are means of adapting products such as publications or software for non-native environments, especially other nations and cultures. More ^

To check if a temporary table already exists before DROPping, use If Object_Id('tempdb..#big') is Not Null Drop table #big BTW, Are SQL Server Temp Tables Really Necessary?

Guidance for project teams building .NET applications with Visual Studio .NET and Visual SourceSafe - Download.

A reminder on "Three/Multi Tier/Layer Architecture/Design" & a Beginner's Guide