Visit a content portal to find information, resources, and help over a wide range of topics, projects, and issues.
By Rajkumar5055 October 2, 2013
Flat files as Source are widely used in SQL Server Integration Services Tool. This article will discuss one common issue with Flat File Date time Columns. (Details can be found in this SSIS MSDN Thread called "SSIS FlatFile Source Datetime Column Format Issue"). Note: DOB column (Datatype: DT_DBTIMESTAMP) has two date formats (DD/MM/YYYY & MM/DD/YYYY).) Observations: I expected the 06/26/1988 value...
By Saeid Hasani October 1, 2013
This article comes up from an MSDN forum post. The problem is how can we sort the letters in a phrase just using T-SQL? To clarify the question, for instance the desired result for CHICAGO must be ACCGHIO." Because SQL is a Declarative Language in Relational System, it does not have arrays. Table is a relational variable that presents a relation, simply it is a Set that has no order. But if someone needs to do this sort in SQL Server...
By Reed Kimble September 29, 2013
Converting a decimal number into its textual representation is nothing new and the Internet is full of examples on ways to do so. The basic idea is to create some kind of look up table for numbers and their respective words (e.g. 0 = "zero", 1 = "one", 2 = "two", etc.) and then provide a method which can take a decimal number like 1234.56 and output a string containing "one thousand two hundred and thirty-four point five six"...
By Isham Mohamed September 28, 2013
Windows 8.1 comes with a hidden feature called “Slide to Shutdown”, it is like the Slide to shutdown facility in Windows Phone. Every one was busy in making shortcut for the SlideToShutdown.exe on desktop and calling it via shortcut key combinations. Mine was a small application that invoke Process class’s Start method C# (i.e. Process.Start();) or Shell()in VB.net. I took my time and started making my idea. Then when I faced an issue...
More featured articles