(Pinal Dave) It is very frequent request to upload CSV file to database or Import CSV file into database. I have previously written article how one can do this using T-SQL over here SQL SERVER – Import CSV File Into SQL Server Using Bulk Insert – Load Comma Delimited File Into SQL Server.
Other News
Change sequence’s current value (CURRVAL) without dropping it
(ittichai) This is not new but I’ve learned about it last week from one of developers when reviewing codes with them for the plan to change the sequence’s current value. Normally I would drop the sequence and create it with START WITH to a new desired number. However, my approach will obviously inv
DB2 10 for z/OS the Belle of the Ball – The IDUG Recap
(Dave Beulke) The annual North American IDUG conference was held in Anaheim, California last week where the latest and greatest information about DB2 was unveiled. The IDUG Board of Directors and especially the Conference Planning Committee did a great job providing qualified users, consultants and
IBM DB2 Users Report that they are More Satisfied than Oracle Database Users
(Conor O’Mahony) Yesterday, I blogged about relative outages for IBM DB2 and Oracle Database, as reported by Solitaire Interglobal. Well, Solitaire also surveyed people in data centers regarding their satisfaction levels with database software. Here is how Solitaire introduce their findings:
MySQL’s Real Partition Key
(Michael McLaughlin) While reviewing some material and explaining list partitioning in MySQL, I heard a rumor that sounded false. The rumor was that you can’t partition on anything other than the primary key column. That’s untrue, you can partition on another column provided it’s an integer column.
Using The XPath String() Function In XmlSearch() To Aggregate Node Text In ColdFusion
(Ben Nadel) Last week, I talked about aggregating XML node text in a mixed-node ColdFusion XML document. In the comments of that post, Kirill pointed out that you could accomplish pretty much the same thing directly in the original xmlSearch() invocation using the XPath string() function.
SQL Server Tips & Tricks: Create Bulk Queries 2
(Mohamed El Ashmawi) In my previous post, I mentioned that sometimes you need to create dynamic queries for SQL servers and that one of the options is to write queries that dynamically creates the needed queries for you.
The WebGrid Helper – Making Selections
(Mike Brind) The WebGrid helper, introduced via ASP.NET Web Pages, provides a means for displaying tabular data easily. This article examines how to enable selection within the WebGrid at row level.
Implementing Dynamic DropDownList in ASP.NET MVC 3 Framework
(Mohammad Azam) Dynamic DropDownLists allows the user to select an item from the first dropdownlist which populates the second dropdownlist based on the selection of the first dropdownlist. In this article we are going to demonstrate how to implement dynamic dropdowns using ASP.NET MVC 3 framework.
InfoSphere MDM Server best practices: Implementing InfoSphere MDM Server for high performance
(David Borean) InfoSphere MDM Server was originally architected with performance and scalability as a key requirement given the demands of the various styles of master data management implementations and specifically the centralized (or transactional) style.